Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can a formula change a cells colour after a given length of time?
Is it possible to have a cell change colour after a given time period?
i.e. change red after 30 days |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can a formula change a cells colour after a given length of time?
Hi Clive
Assuming the cell you want to highlight contains a date, (A1 in this example) then try highlighting your cell, then FormatConditional Formattingdropdown to select Formula is=TODAY()-A130 FormatSelect Font, Border or Patterns and colour to your choice. The cell(s) in question to have the formatting, do(es) not neceesarily have to hold the date, but obvioulsy the cell used as the reference does. You can combine things with for example =AND(TODAY()-A1=30,TODAY()-A1<90) That could be one colour, and there are 2 more formats you can add to have different colours for different date ranges. -- Regards Roger Govier Clive Humphries wrote: Is it possible to have a cell change colour after a given time period? i.e. change red after 30 days |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Capturing The First Change in a Formula | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Change Font Colour Automatic When Formula Match | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How can I change the colour of cells using an IF function? | Excel Worksheet Functions |