Conditional Formatting for dates

[Richhall]

Hi

I have a spreadsheet that is similar to below:

A B C D E F G H I J ....

January 1 2 3 4 5 6 7 8 9 10...
a a b b b a b b a b
February 1 2 3 4 5 6 7 8 9 10...
c a c b b a b b a b

and so on.

So in one column the months are listed, then corresponsingly for two
rows there is the date until the end fo the month, and then under each
date is basically a task. I know it would probably be easier to
change the spreadsheet but it needs to be in this format. I want to
grey out dates that have passed, i.e before todays date. I can use
=TEXT(TODAY()"m") to create a corresponding reference to the month and
grey this out with conditional formatting, and also can obviously grey
out numbers in the dates less than todays "d" similarly, the problem
is this greys out all dates up to December. Is there a way I can uses
AND or something to just grey out numbers relating to the months that
have passed?

Cheers

Rich

 

[Bob Phillips]

Use a formula of

=DATEVALUE(B2&"-"&$A2&"-"&YEAR(TODAY()))

in CF

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Richhall]

Use a formula of

=DATEVALUE(B2&"-"&$A2&"-"&YEAR(TODAY()))

in CF

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)











- Show quoted text -

Cheers I shall give that a go.

Rich