conditional formatting

M

Mark Sixel

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.
 
B

Bob Phillips

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)
 
Top