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! |
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. |
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! |
All times are GMT +1. The time now is 09:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com