| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color cell text based on date
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
You can do this with Conditional Formatting on the Format menu.
Select the cells you want to format, change "Cell Value Is" to "Formula Is" and use a formula like =A1TODAY() Change the A1 to the first selected cell. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Byron" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Color cell text based on date
Can this be done with VBA?
"Chip Pearson" wrote: You can do this with Conditional Formatting on the Format menu. Select the cells you want to format, change "Cell Value Is" to "Formula Is" and use a formula like =A1TODAY() Change the A1 to the first selected cell. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Byron" wrote in message ... 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 | |||
| Color cell text based on date | Excel Programming | |||
| cell color change based on due date | New Users to Excel | |||
| Change cell color based on date | Excel Programming | |||
![Byron[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
