ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Change cell colour by date (https://www.excelbanter.com/new-users-excel/70245-change-cell-colour-date.html)

Dri February 8th 06 08:57 AM

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

Stefi February 8th 06 09:10 AM

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


Max February 8th 06 12:05 PM

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




Max February 8th 06 12:16 PM

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
---



Dri February 8th 06 04:17 PM

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
---




Max February 8th 06 11:29 PM

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





All times are GMT +1. The time now is 07:30 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com