Quday001-Conditional Formatting
 

I have a column containing dates (A1:A100) in date format.
Colour of all the cells in that column (A1:A100) is yellow and I want to the
blank cells as it is.


Highilighted the required cells (A1:A100) and Given formula in condition
formatting
=AND(TODAY()-A1365,A10)

Is it possible to do the same in multiple column
ie., (A1:G100)

Quday001-Conditional Formatting
 

Yes, but if you want the condition to always relate to column A you
will need to amend the formula slightly. Highlight A1:G100 with A1 as
the active cell, click on Format | Conditional Formatting, select
Formula Is and put this formula in the box:

=AND(TODAY()-$A1365,$A10)

Click the Format button and set the format as you would like, then OK
out.

Hope this helps.

Pete

On Jul 11, 3:10*pm, Udayan wrote:
I have a column containing dates (A1:A100) in date format.
Colour of all the cells in that column (A1:A100) is yellow and I want to the
blank cells as it is.

Highilighted the required cells (A1:A100) and Given formula in condition
formatting
=AND(TODAY()-A1365,A10)

Is it possible to do the same in multiple column
ie., (A1:G100)