How can it be blank and be Sunday?

To test for Sunday, use a formula of

=WEEKDAY(A1)=1

--
HTH

Bob Phillips

"Ajit Munj" <ajitmunj@microsoft.com> wrote in message
news:6DD2B83B-60A7-435A-945E-334FB15B34B9@microsoft.com...
> 1. I want to format the cell by 2 conditions. e.g. in range a1:z1, fill
the
> cell with
> red colour(Fill colour) only if it is blank and if it contains "Sunday",
> show it with red colour (Font Colour). HOw can I do this?
> 2. I want to insert the comment conditionally e.g. if the cell contains
> "IT" insert the comment "India Today", "TOI" insert comment as "Times of
> India" etc. How Can I
> perform this operation?
>
> Ajit
> --
> Knowldege is Power