I would like to do the next:

If the value of a range of cells (e.g. b1:x1) exceed the value of a
single cell (e.g. A1), cell A2 has to be marked by a color. If B1:X1<A1
then blank A2 cell.

I know how to compare the range with the single cell and how to give
the cell A2 a color by VBA, but how to combine the two???


--
Geald Baalhuis
------------------------------------------------------------------------
Geald Baalhuis's Profile: http://www.excelforum.com/member.php...o&userid=27886
View this thread: http://www.excelforum.com/showthread...hreadid=473915