Forum Discussion
Solved
How to change the colour of a cell based on another value
Hi Everyone, Happy New Year! Looking for some help please. I have already applied conditional formatting to this spreadsheet to highlight improvement (green) or decline (red) in figures. Howeve...
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.