Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
Hi
select the cells choose format / conditional formatting choose cell value is choose less than type =today() click the format button - set your format OK twice Cheers julieD "Joooooooo" wrote in message ... How do I conditionally format some cells so that the ones containing a date that comes before today are highlighted? I've tried everything I can think of! (Mind you, that's not much) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
conditional formatting conflict? | Excel Worksheet Functions | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |