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