| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Change Color of Cell based on Date and today's date.
Hi,
I am trying to create a tasker for work. I need the task to highlight in red if the suspense date has already passed. (i.e., if the task was due 29 jun and today is 9 jul, i need it to highlight red. If the task is due between todays date and 6 weeks out, I need it to highlight yellow. If the task is due more than 6 weeks out, I need it to highlight Green. Does anyone know how to do this? Also when in puting a formula, is there a way that the formula can automatically change for that row number... for example if the formula is =b7-b3, when i move to b8 is there a way to write the formula so i don't have to individually type each row number in the formula? Sorry if this confuses anyone... Thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
| I'd like to conditionally format a cell based on today's date | Excel Discussion (Misc queries) | |||
| cell color change based on due date | New Users to Excel | |||
| Change cell color based on date | Excel Programming | |||
Threaded Mode
