Many thanks to you anyway.
I thought it was a lohg shot.
--
Big Rick


"shadestreet" wrote:


I am not clear on what your goal is, but have you tried conditional
formatting? (under "Data").

You can add up to three conditions for a cell, the conditions are
logical tests that can change the color depending on the contents of
the cell. It is limited, but it may be the solution if you want to
avoid creating a macro.


--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: http://www.excelforum.com/member.php...fo&userid=7092
View this thread: http://www.excelforum.com/showthread...hreadid=473528