Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color cell text based on date
Thanks for the input, but I was actually trying to find a way with VBA to do
it automatically. Thanks "Gary''s Student" wrote: 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 |
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 | |||
Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
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 |