| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting highlight the cell today's date
You could have a time value as well in the cell.
If you format the cell as general, does it contain an integer like 37910 or does it contain a decimal as well such as 37910.25 The test described tests if it contains 37910 and would fail if it contained 37910.25 37910 is the date serial number stored for Oct 16, 2003 It is like testing if =Today()=Now() They would only be equal at midnight. -- Regards, Tom Ogilvy "hglamy" wrote in message ... Doesn't work with me in XL XP ? Any idea what goes wrong ? Regards, H.G. Lamy "tegger" schrieb im Newsbeitrag ... thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| Conditional Formatting based on Today's Date | Excel Discussion (Misc queries) | |||
| How do I highlight today's date in a monthly schedule spreadsheet. | Excel Discussion (Misc queries) | |||
| How do I highlight today's date in a monthly schedule spreadsheet. | Excel Discussion (Misc queries) | |||
| How do I highlight a cell using conditional formatting and dates | Excel Worksheet Functions | |||
Threaded Mode
