Conditional Format: Columns w. Date as Header

[Smitty15]

I am trying to conditionally format columns with the header as dates. I would like to format based on the following:


Dates > Today = Format entire column Black

Dates = Today = Format entire column Yellow

Dates < Today = nothing


How can I format an entire column based on the value of the header as a date, and as a function less than or equal to today's date?

 

[kchiba]

Smitty,


You must apply the CF to the range that you want and insert 3 Rules. Notice that only the row is absolute.


=A$1>TODAY()

=A$1<TODAY()

=A$1=TODAY()


and they all apply to the range you want them to


=$A$2:$C$34