View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jagruti Jagruti is offline
external usenet poster
 
Posts: 5
Default Conditional formatting and weekdays

Hi,
Need some help for the captioned subject.
I am entering a date on the top cell of col B

Then there are numbers from 1 to 31 from cell B5 downwards.
These numbers represent the day of the month.

I want to highlight the cells that are having sundays with
one colour and those out of month with another colour.

Is it possible?
Thanks,
Jagruti.