| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
| auto highlighting of cells when clicked on | Excel Discussion (Misc queries) | |||
| Highlighting every other row? | Excel Discussion (Misc queries) | |||
| Highlighting a Row | Excel Worksheet Functions | |||
| Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
Linear Mode
