Forum Discussion
RhiLew
Jan 06, 2024Copper Contributor
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...
- Jan 06, 2024
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)
RhiLew
Jan 06, 2024Copper Contributor
Oh wow - you are my hero! Thank you so much 🙂
Lorenzo
Jan 06, 2024Silver Contributor
RhiLew You're welcome & Thanks for marking the solution (helps people who Search)
- RhiLewJan 21, 2024Copper Contributor
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!
- HansVogelaarJan 21, 2024MVP
- RhiLewJan 21, 2024Copper ContributorOh you are the best thank you so much! I can't believe the support of this community; so helpful; and so quick to respond - it's so appreciated.
(also kicking myself at how close I was to figuring it out myself!! 🤣)
Thank you again