IF formula with conditional formating help please

  • Thread starter Thread starter ferde
  • Start date Start date
F

ferde

Green 95%-100%
Yellow 85%- 95%
Red <85%

....A ....B
100% 70%

I would like to highlight cells with a color the cell meets certain
criteria. I think I need to use an IF formula . In my example here ...if
B2 is within 85%-94% of A2 then the answer would be "yellow" but if B2 is <
85% of A2 then it would be "RED". I thought I would plug this formula into
the conditional format of the cell in order for it to highlight the cell
aproppriately but I may be approaching this all wrong and would love some
help.
 
you would need to have three conditional formats on B2 cell

if cell value is greater than ....=0.95*A2
if cell value is between ......=0.85*A2 and =0.95*A2
if cell value is smaller than ....=0.85*A2

after entering the first condition and format
click onto "add" etc.

you can copy the format onto other cells using format painter
 
This works great for both a cell value > 95 and < 85 but excel gives me an
error message when I try and plug in if the cell value is between
......=0.85*a2 and =0.95*A2. The error message said "you may not use unions
or intersections for conditional formatting entries." Maybe I am putting
the formula in wrong. I used the word AND but that may not be right. Any
ideas?
 
I figured it out using your example.... I just couldnt use the word AND ....
Thank you so much for your quick reply.
 
Back
Top