format certain values
 

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?

format certain values
 

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?