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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color cell text based on date
Byron:
Try Dim UserRange As Range, rng As Range Set UserRange = Range("B2:B10") For Each rng In UserRange If IsDate(rng) And rng < Date Then rng.Font.ColorIndex = 3 End If Next -- http://www.vba.com.tw/plog/ "Byron" wrote: 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 |
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 | |||
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 |