Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding an alarm
Hello I need some help.
I have a sheet and in the cell C4, the start date of a temporary vendor is entered. Cell D4 has a formula to work out the date which the vendor expires (+ 60 days) I want a formula to let me know when cell D4 is out of date ie on or after todays date. Ideally I would like for the cell to turn a different colour. Can any of you brain boxes help me? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding an alarm
Hi Atomic,
Try using this formula: =IF(TODAY()D4,"Expired","In Date") and then apply conditional formatting to the cell containing the formula to change the colour when it reads 'Expired' HTH Regards Michael. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding an alarm
set a conditional format where th ecell value (Today()+60) and set is to
turn the cell background red. no need for complex formulae " wrote: Hello I need some help. I have a sheet and in the cell C4, the start date of a temporary vendor is entered. Cell D4 has a formula to work out the date which the vendor expires (+ 60 days) I want a formula to let me know when cell D4 is out of date ie on or after todays date. Ideally I would like for the cell to turn a different colour. Can any of you brain boxes help me? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alarm | Excel Worksheet Functions | |||
Alarm Timer | Excel Programming | |||
Alarm | Excel Programming | |||
Alarm Clock? | New Users to Excel | |||
How can a set an alarm in Excel? | Excel Discussion (Misc queries) |