Forum Discussion

RhiLew's avatar
RhiLew
Copper Contributor
Jan 06, 2024
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...
excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    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)

     

Lorenzo's avatar
Lorenzo
Silver Contributor
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's avatar
RhiLew
Copper Contributor
Jan 06, 2024
Oh wow - you are my hero! Thank you so much 🙂
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jan 06, 2024

    RhiLew You're welcome & Thanks for marking the solution (helps people who Search)

    • RhiLew's avatar
      RhiLew
      Copper Contributor
      Jan 21, 2024

      Lorenzo 

       

      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!

Resources