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 |
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 |
All times are GMT +1. The time now is 08:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com