Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format <=Today()
Hello
I want to apply conditional Formatting to a range of cells dependant on the current date. All cells are formatted and populated with dates, and I simply need them to aplly formatting based on whether the date is <= the present date. I've tried Formula Is <=today() but thinks it's text and chnages it to Formula Is ="<=today()" So how do I do it? Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format <=Today() | Excel Worksheet Functions | |||
conditional format for if month(today) = xxx | Excel Worksheet Functions | |||
Conditional formating using today() +/- 180 days | Excel Worksheet Functions | |||
Conditional Format (month and year) = Today() | Excel Worksheet Functions | |||
Conditional Formatting ... Today() & More | Excel Worksheet Functions |