Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell color change based on Date
What formula would I used to change a range of cells a different color based on the current date?
For example if I have a date of 1/1/2015 in a cell can I change adjoining cells a different color based on the current date? Last edited by Rocky Williams : December 29th 14 at 06:28 PM |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell color change based on Date
What formula would I used to change a range of cells a different color
based on the current date? For example if I have a date of 1/1/2015 in a cell can I change adjoining cells a different color based on the current date? Sounds like a job for Excel's "Conditional Formatting." For example, suppose 1/1/2015 in cell A1, and you want to highlight cells B1:H1 when A1 is after the current date. Then select B1:H1, use the "Conditional Formatting" command with the formula =$A1TODAY() and choose the format fill color of your choice. The exact way to choose the "Conditional Formatting" command and its options depends on what version of Excel you have. If in doubt, try Excel's built-in "Help." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Color of Cell based on Date and today's date. | Excel Worksheet Functions | |||
change fill color of a range of cells based on color of a cell? | Excel Programming | |||
cell color change based on due date | New Users to Excel | |||
Change cell color based on date | Excel Programming | |||
Browse Forms Controls and change TextBox color based on cell color | Excel Programming |