Another Conditional Formatting Question

[Guest]

I have 898 rows of information spread across 13 columns. Column "G" has
dates (898 *different* dates...). What I want to do is set a conditional
formula to change the font, of the whole row, only if the date is older than
"today". I must be able to select all of the cells and set the formatting at
once, but I can't seem to get it correct. Thanks.

 

[VBA Noob]

Hi,

I would suggest only selecting the 13 columns not the whole workbook.

Then in Conditional Formatting enter.


=IF($G3<TODAY(),TRUE,FALSE)

VBA Noob

 

[Guest]

Thanks Noob,
However that formula also highlights rows that are "newer" than today as
well. Thinking back to my previous post, I may not have explained that I
only want rows with dates older than "today" to be highlighted.

 

[Gord Dibben]

Select Rows G1:G898

Format>CF>Formula is:

=$G1<TODAY()


Gord Dibben MS Excel MVP

 

[Guest]

That's it! Thanks Gord!

Select Rows G1:G898

Format>CF>Formula is:

=$G1<TODAY()


Gord Dibben MS Excel MVP