Auto Highlighting!!

  • Thread starter Thread starter castruck
  • Start date Start date
C

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