Quday001-Conditional Formatting

[Udayan]

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()-A1>365,A1>0)

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

 

[Pete_UK]

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()-$A1>365,$A1>0)

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

Hope this helps.

Pete