Good evening Khaji00

This is possible, but a bit difficult to explain, so, loath as I am to
doing so, I have attached a small file demonstating how to. You need
to use the conditional formatting tool as shown in the example file.

HTH

DominicB


+-------------------------------------------------------------------+
|Filename: Book2.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3526 |
+-------------------------------------------------------------------+

--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=381433