Conditional Formating comparing the two columns

H

Harry

If column "A2" is less than the value in column "B2" I want to change the
color of "A2"
 
M

Max

Select the range, eg A2:A10 (A2 active),
then apply CF using Formula Is:
=AND(A2<B2,ISNUMBER(B2))
Format to taste > Ok out

The ISNUMBER(B2) is an additional precaution
to avoid spurious triggers caused by possible text entries in col B
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
 
H

Harry

Thanks Max works like a charm.

Max said:
Select the range, eg A2:A10 (A2 active),
then apply CF using Formula Is:
=AND(A2<B2,ISNUMBER(B2))
Format to taste > Ok out

The ISNUMBER(B2) is an additional precaution
to avoid spurious triggers caused by possible text entries in col B
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
Click to expand...
 
Top