Another Conditional Formatting Question

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.

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

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.


"VBA Noob" wrote:

>
> 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
>
>
> --
> VBA Noob
> ------------------------------------------------------------------------
> VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
> View this thread: http://www.excelforum.com/showthread...hreadid=563981
>
>

Select Rows G1:G898

Format>CF>Formula is:

=$G1<TODAY()


Gord Dibben MS Excel MVP

On Sat, 22 Jul 2006 07:49:02 -0700, 1320_Life
<[email protected]> wrote:

>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.

That's it! Thanks Gord!

"Gord Dibben" wrote:

> Select Rows G1:G898
>
> Format>CF>Formula is:
>
> =$G1<TODAY()
>
>
> Gord Dibben MS Excel MVP
>
> On Sat, 22 Jul 2006 07:49:02 -0700, 1320_Life
> <[email protected]> wrote:
>
> >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.
>
>