Conditionally Format two Cells based on the % of another cell

[Dougie1]

Hi,

I wonder if anyone can help?

Am using Excel 2016

I want to conditionally format 2 columns of cells based on the % of another column

What I am trying to do is format cells A2 & B2 based on a % of C2 (which is hidden)

I would like cells A2 & B2:

To be filled Green if they are between 71% and 80% of C2

To be filled Orange if they are between 81% and 90% of C2

To be filled Red if they are 91% and over of C2

I would then like to do the same for A3 & B3 based on a % of C3 - and so on down the columns

Can anyone advise please?

Many thanks,

D

 

[JoeMo]

1. Select all the cells in cols A & B you want to format conditionally
2. Home>Conditional Formatting>New Rule>Use a formula
3. Formula for the green fill is: =AND(A2/$C2>=0.71,A2/$C2<=0.8)

choose the format and click OK. Repeat for orange and red using the appropriate limits for each.

 

[Dougie1]

Thank you so much JoeMo - that works a treat!

Much appreciated

D

 

[JoeMo]

You are welcome - thanks for the reply.