Auto Highlighting!!

[castruck]

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

 

[Guest]

Hi,

It can be done by conditional formatting.

Format> Conditional Formatting

Thanks,

 

[Gord Dibben]

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

 

[Guest]

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

 

[castruck]

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