Auto Highlighting!!
 

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

Auto Highlighting!!
 

Hi,

It can be done by conditional formatting.

Format Conditional Formatting

Thanks,
--
Farhad Hodjat


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

Auto Highlighting!!
 

When is "late"?

Today is late?

Assuming due date in E1

Select the entire row and FormatConditional FormattingCondition1Formula 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, 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..

Auto Highlighting!!
 

Hi,

FormatConditional FormattingCondition1Formula is:

=$E1=TODAY() for due reports
Format to a pattern color say green
FormatConditional FormattingCondition2Formula 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 FormatConditional FormattingCondition1Formula 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, 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..

Auto Highlighting!!
 

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