| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If TODAY = [Certain Date in Row], Highlight this row?
I'm tracking a bunch of my little projects/tasks via an excel file. It has their "Production Date" as a column, and I was wondering if it would be possible to highlight them in RED or something if it's 90+ after the date listed in Production Date. So, here's the logic I'm thinking, in pseudocode form: (Assume the row is 1, and Prod Date is Col. A.) If (TODAY = A1+90) A.BackgroundHighlight == RED Yeah it's kinda java pseudo code, but I did it just so you knew exactly what I was trying to do Is it possible, and if so, how? -- sasquatchbill ------------------------------------------------------------------------ sasquatchbill's Profile: http://www.excelforum.com/member.php...o&userid=36550 View this thread: http://www.excelforum.com/showthread...hreadid=565747 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUM based on Date < TODAY() | Excel Discussion (Misc queries) | |||
| insert date | Excel Worksheet Functions | |||
| How to return a value between date ranges | Excel Worksheet Functions | |||
| How do I stop today() from updating date on saved spreadsheets? | Excel Discussion (Misc queries) | |||
| Today() or Date() function help | Excel Discussion (Misc queries) | |||
Threaded Mode
