Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Is a cell color change possible with a formula?
Is it possible to have a cell background color change when a particular
condition is met? In this case, specifically a DATE. When an item is entered in a row, one of the entries is the current date. Then when the item is complete, a "completed by" date is also entered in a different cell and yet another cell displays the amount of days an item took to get completed. Is it possible that that 1st cell with the entered date can turn red when 3 days have gone by and nothing has been entered in the c"completed by" cell? Thanks for reading! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Is a cell color change possible with a formula?
"Edward" wrote in message
... Is it possible to have a cell background color change when a particular condition is met? In this case, specifically a DATE. Look up "Conditional Formatting" in Excel Help. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Is a cell color change possible with a formula?
Yes - conditional formatting use formula =today()-your cell reference with
the date=3 "Edward" wrote: Is it possible to have a cell background color change when a particular condition is met? In this case, specifically a DATE. When an item is entered in a row, one of the entries is the current date. Then when the item is complete, a "completed by" date is also entered in a different cell and yet another cell displays the amount of days an item took to get completed. Is it possible that that 1st cell with the entered date can turn red when 3 days have gone by and nothing has been entered in the c"completed by" cell? Thanks for reading! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change cell color within a formula... | Excel Discussion (Misc queries) | |||
How do I change the color of a cell in a logic formula | Excel Discussion (Misc queries) | |||
If Formula to change cell color | Excel Discussion (Misc queries) | |||
Change color in cell if contains formula? | Excel Discussion (Misc queries) | |||
Cell color change in formula | Excel Worksheet Functions |