Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Quday001-Conditional Formatting
2 views
Skip to first unread message
Udayan
Jul 11, 2008, 10:10:04 AM7/11/08
to
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.
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
Jul 11, 2008, 2:01:42 PM7/11/08
to
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:
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
0 new messages