Conditional Formating comparing the two columns
 

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

Conditional Formating comparing the two columns
 

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
---
"Harry" wrote:
If column "A2" is less than the value in column "B2" I want to change the
color of "A2"

Conditional Formating comparing the two columns
 

Thanks Max works like a charm.

"Max" wrote:

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
---
"Harry" wrote:
If column "A2" is less than the value in column "B2" I want to change the
color of "A2"

Conditional Formating comparing the two columns
 

Happy to hear that, Harry.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500, Files:362, Subscribers:62
xdemechanik
---
"Harry" wrote in message
...
Thanks Max works like a charm.