Hi Jagruti,

Do the following. Select the first cell which contains 1 i.e. B5. Go to
Format Conditional Formatting. Select formula is and enter the
following formula in the adjoining box:
=WEEKDAY(DATE(YEAR($B$1),MONTH($B$1),B5))=1
select a format color for the cell. This will format all cells which are
sundays to your conditional format color. As for the other cells, you
can directly choose a required background color. The conditional format
will override this for sundays.

--------------
Mangesh

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!