Conditional Formatting with multiple columns

[whistope]

Hello!

I am trying to highlight the row in green that if column e is greater than 500 and column f is greater than 5. also highlight in yellow if column e is less than -500 and column f is less than -5. Also if there is a zero in both of the cells I do not want it to highlight at all.


(C) (D) (E) (F)
PTD PTD * Variance % Var
Actual *Budget

64304 66836.64 -2532.64 -3.79
-1732.73 -2088.65 355.92 17.04
-619 -619 0 0

Any help is GREATLY appreciated!

 

[Special-K99]

Select C1

Conditional Formatting
New Rule
Use a formula to determine...
2 Rules needed

=(AND(E1>500,F1>5))
format as green

=(AND(E<-500,F1<-5))
format as yellow

Use Format painter (paintbrush icon) to copy to other cells

 

[whistope]

thank you for your quick response but ...it did not work Some of the conditions are met (for example the value in column e is greater than 500 but the value in column f is less than 5) so it shouldn't be highlighted and it is - other times some of the values are met in both columns (for example e's value is 1928.47 and f's value is 72.13) and it isn't highlighted. Does it have anything to do with what cell I type the conditional formatting formulas into?