Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell color based on date
Dear Experts,
I would like my users to be able to input a date in a cell, then Excel automatically calculates the elapsed duration in days from the inputted date to today's date, and changes the color of the cell to one of four colors, based on the 3 user-specified durations that correspond to the three colors. So if the user-specified durations are 10 days (if duration d =< 10, cell color = red), 20 (if 10< d =<20, cell color = orange), and 30 (if 20< d =<30, cell color = yellow, and if d30 cell color = green), the cell color will automatically change based on today's date. Ideally, the user-specified thresholds can be different for each cell, or at least for each column. Can this be done with conditional formatting or is code required? I'm new at both so any help would be greatly appreciated! Thank you, RRP333 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change color of point in series based on date | Charts and Charting in Excel | |||
Change tab color based on current color of a cell | Excel Discussion (Misc queries) | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
cell color change based on due date | New Users to Excel | |||
Browse Forms Controls and change TextBox color based on cell color | Excel Programming |