conditional formatting

[RichardO]

Hello all,

I would like to know how to color the font of column L red if th
values of the cells in that column is not the same as values of cels i
column J.

Thanks for helpin

 

[Biff]

Hi RichardO!

I'll assume the ranges are J1:J100 and L1:L100.

Select the range to format in col L.
Goto Format>Conditional formatting
Formula is: =COUNTIF($J$1:$J$100,L1)=0
Select your formats
OK out

Biff