Walt Matchim Wrote:
Works great except that it turns 2 cells Red. (Active and the cell
directly below)
Do I need additional Conditional Formating to turn off highlighted
cell.

Thanks
Walt

Conditional Formating doe's not affect the active cell for being
active, it only works when the condition is fulfilled whether the cell
is active or not.
ilan


--
ilanr01
------------------------------------------------------------------------
ilanr01's Profile: http://www.excelforum.com/member.php...o&userid=26797
View this thread: http://www.excelforum.com/showthread...hreadid=401167