Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Conditional Formatting on 'Today'
I want to set up a conditional format in an Excel spreadsheet using the Today
function. If the date in the cell is greater than TODAY leave it but if the date is less than today highlight the cell. Has anyone got a clue on the conditional formatting? -- Confused but battling on |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Conditional Formatting on 'Today'
See http://www.xldynamic.com/source/xld.CF.html#due
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Madame Artois" wrote in message ... I want to set up a conditional format in an Excel spreadsheet using the Today function. If the date in the cell is greater than TODAY leave it but if the date is less than today highlight the cell. Has anyone got a clue on the conditional formatting? -- Confused but battling on |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format <=Today() | Excel Worksheet Functions | |||
Conditional Format <=Today() | Excel Worksheet Functions | |||
Formatting today() | New Users to Excel | |||
Conditional Formatting Cell < Today() | Excel Worksheet Functions | |||
Conditional Formatting ... Today() & More | Excel Worksheet Functions |