conditional formatting
 

Is there any way to highlight an entire row of data (saw with red font color)
if a leading cell meets a certain criteria.

Thanks.

conditional formatting
 

Sure,

select the whole row
go to CF
change Condition 1 to Formula Is
add a formula of =$A1=20 for example
format as normal

note the $ in the formula, that means that each cell in the row is testing
the value in A, not in the cell itself

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Mark Sixel" <Mark wrote in message
...
Is there any way to highlight an entire row of data (saw with red font
color)
if a leading cell meets a certain criteria.

Thanks.