Setup conditional formatting on both columns.

In conditional formatting setup as follows:

Colum A ...

Cell Value is Greater than B1


colum B ...

Cell Value is Greater than B1

In each change font colour to say RED.


--
PeterG
------------------------------------------------------------------------
PeterG's Profile: http://www.excelforum.com/member.php...o&userid=16485
View this thread: http://www.excelforum.com/showthread...hreadid=381527