Condition Format a Day that resulted from a formula
Formula is:
=WEEKDAY($B3,2)5
--
David Biddulph
"Sunnyskies" wrote in message
...
Morning,
I have a date in column B3 formated as 15-Feb-2007. Now in column C3 I
have
copied this date - =B3 and changed the format to 'ddd' resulting in Thu.
Now coping cells B3 and C3 down I would like the row to change colour if
the
date/day becomes a Saturday (Sat) and Sunday (Sun).
It should be simple but the weekend mindset has set in.
Thanks
|