select the range you want to format, click on Format, Conditional Formatting,
change the box that says Cell Value is to Formula Is, enter the following
formula:
=OR(AND($D1="pa",$E1<5),AND($D1="nb",$E1<0),AND( $D1="p5",$E1<3))

Select Format, select Patterns, choose a colour to highlight with, and you
are A for Away

--
Hth

Kassie Kasselman


"Keep It Simple Stupid" wrote:

I have 3 different codes in column D: PA, NB, and P5.
In column E I have different rates. I need to highlight the rows where PA
does not equal $10, NB does not equal $0, and P5 does not equal $3.
Is there a way to highlight the entire row or even one of the cells?