Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Change cell colour by date
Hi All
I'm working on a spreadsheet for a maintenance program. I'm looking for a way to change the cell colour depending on when a task is due. For example: when a monthly task is due I would like the cell colour to change to remind me that it is due in a week. Thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Change cell colour by date
Use Conditional formatting, see details in Help!
Regards, Stefi €žDri€ť ezt Ă*rta: Hi All I'm working on a spreadsheet for a maintenance program. I'm looking for a way to change the cell colour depending on when a task is due. For example: when a monthly task is due I would like the cell colour to change to remind me that it is due in a week. Thanks |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Change cell colour by date
Perhaps a quick play to ease you in as well ?
Assuming the due dates are in col B, in B2:B10 (say), and we want the entire row(s) to appear shaded yellow if the due date is <= 7 days from today Select row2 down to row10 (select the row headers) [this ensures that A2 is active] Click Format Conditional Formatting Under Condition 1, make the settings: Formula is: =AND($B2<"",$B2-TODAY()<=7) Click Format button Patterns tab Yellow OK Click OK at the main dialog -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Dri" wrote in message ... Hi All I'm working on a spreadsheet for a maintenance program. I'm looking for a way to change the cell colour depending on when a task is due. For example: when a monthly task is due I would like the cell colour to change to remind me that it is due in a week. Thanks |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Change cell colour by date
Select row2 down to row10 (select the row headers)
Just a clarification that we could actually select rows beyond row10, i.e. pre-format ahead of dates input in col B, since the CF formula includes checks for blank cells in col B as well (via the part: $B2<""). -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Change cell colour by date
Max,
Thanks for taking the time out to help me. You've pointed me in the right direction perfectly. Best wishes "Max" wrote: Select row2 down to row10 (select the row headers) Just a clarification that we could actually select rows beyond row10, i.e. pre-format ahead of dates input in col B, since the CF formula includes checks for blank cells in col B as well (via the part: $B2<""). -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Change cell colour by date
You're welcome, Dri !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Dri" wrote in message ... Max, Thanks for taking the time out to help me. You've pointed me in the right direction perfectly. Best wishes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can i change cell colour depending on month of date in cell? | Excel Discussion (Misc queries) | |||
How do you change the default colour a cell is highlighted in? | Excel Discussion (Misc queries) | |||
Change cell to red when date in other cell is red | Excel Discussion (Misc queries) | |||
cell colour change | Excel Worksheet Functions | |||
HOW TO USE A FORMULA TO CHANGE CELL COLOR ACCORDING TO DATE RANGE. | Excel Worksheet Functions |