Forum Discussion
How to change the colour of a cell based on another value
Hi RhiLew
Happy New Year too
or (even better) Make the name cell (A:B) fill red if the value of any M:Q < K ?
Conditional Formatting rule that applies to (with the above example) $A$5:$B$9:
=COUNTIF($M5:$Q5, "<" & $K5)
Hi sorry for jumping on the post. I am currently trying to do the same kind of thing but with a variable rule. My sheet consists of F - Cost in £, H - Sold in £ and I- Profit in £. I have a formula to complete H once a value is entered in G but I am trying to change the text colour in A-J once I is complete. I have tried both methods stated in the thread but must be missing something.
- Oh wow - you are my hero! Thank you so much 🙂
I wonder if you might be able to help me further with the formatting of this same spreadsheet please?
I have been playing around with the formula to try and get it to make a name turn green if the number reaches >90.
Similarly, I need another colour if it falls <75.
I am not having much luck and I bet it is something very similar to the original formula that you gave me?
Thanks in advance!
