conditional formatting

  • Thread starter Thread starter RichardO
  • Start date Start date
R

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