I use Excel to service appraisal reports.. pretty much have the info
logged in with the due date of the report..

What I want to have happen is that when the report is late it will
automaticlly highlight the whole row..

Hi,

It can be done by conditional formatting.

Format> Conditional Formatting

Thanks,
--
Farhad Hodjat


"(E-Mail Removed)" wrote:

> I use Excel to service appraisal reports.. pretty much have the info
> logged in with the due date of the report..
>
> What I want to have happen is that when the report is late it will
> automaticlly highlight the whole row..
>
>

When is "late"?

Today is late?

Assuming due date in E1

Select the entire row and Format>Conditional Formatting>Condition1>Formula is:

=$E$1<=TODAY()

Format to a pattern color you like and OK your way out.


Gord Dibben MS Excel MVP

On Wed, 22 Aug 2007 13:31:04 -0700, (E-Mail Removed) wrote:

>I use Excel to service appraisal reports.. pretty much have the info
>logged in with the due date of the report..
>
>What I want to have happen is that when the report is late it will
>automaticlly highlight the whole row..

Hi,

Format>Conditional Formatting>Condition1>Formula is:

=$E1=TODAY() for due reports
Format to a pattern color say green
Format>Conditional Formatting>Condition2>Formula is:

=$E1>=TODAY() for past due reports
Format to a pattern color say red

if you want whole row be colored you should copy cell E1 and past especial>
formatting to all cells
--
Farhad Hodjat


"Gord Dibben" wrote:

> When is "late"?
>
> Today is late?
>
> Assuming due date in E1
>
> Select the entire row and Format>Conditional Formatting>Condition1>Formula is:
>
> =$E$1<=TODAY()
>
> Format to a pattern color you like and OK your way out.
>
>
> Gord Dibben MS Excel MVP
>
> On Wed, 22 Aug 2007 13:31:04 -0700, (E-Mail Removed) wrote:
>
> >I use Excel to service appraisal reports.. pretty much have the info
> >logged in with the due date of the report..
> >
> >What I want to have happen is that when the report is late it will
> >automaticlly highlight the whole row..
>
>

......was totally doing all this complicated crap to try to get it to
work and i never thought of that... wow... talk about brain farts