Is there a way to dynamically ‘force’ a cell colour (eg. A1) to be the same as another cell’s colour (eg. B1) [where the source cell’s colour (B1) could be anything and might change from time to time]? Understand I could simply copy-paste-format but as the ‘source’ cells will be changing colour regularly don’t want to be bound to the manual process but have the colour changes happen automatically.
Share
What is the logic behind the color of C5?
Why is C5 colored dark blue?
Does C5 need to be a specific type of TEXT string?
Is there something within the TEXT string that denotes it should be Blue?
Apparently all your doing in C12 is cutting out the 18 and subtracting 3 to make it 15.
The only thing I can see is that you need a two digit number in C5 to get any response, else you get a blank cell.
MIKE
http://www.skeptic.com/