If you need any help with the conditional format (white on white), let
me know. The solution I gave you is over complicated and could be made
simplier, but at least the way I have done it, you can follow it.
You don't really need to put the days of the week down, just change the
data validation to say if weekday = 1 then do an indirect to D58, else
do an indirect to C58. I did it the way I have, to demonstrate it. Try
and have a go at doing it the way I describe.
G
--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile:
http://www.excelforum.com/member.php...o&userid=17084
View this thread:
http://www.excelforum.com/showthread...hreadid=528681