| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color cell text based on date
Use conditional formatting:
Format Conditional Formatting... and enter value greater than =TODAY() and select a distinct format. Then copy the formatting down the column -- Gary''s Student "Byron" wrote: I need a way to color all dates in a column if the date is later than today. I can do it using the autofilter, but if there are no late dates, it colors the whole workbook. Help. Byron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add values based on text color with the criteria of a date | Excel Worksheet Functions | |||
| Color cell text based on date | Excel Programming | |||
| cell color change based on due date | New Users to Excel | |||
| Changing a cell color based on date entry ... | Excel Programming | |||
| Change cell color based on date | Excel Programming | |||
Hybrid Mode
