| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conditional format a date in Excel
Yes, that is exactly what I wanted.
Al "flummi" wrote: If this is still open: Your date in B1: select format--conditional format select "formula is" type =B1<today()+30 click "format" select the formatting you want click ok click ok copy B1 and "paste special--format" into all cells that need formatting. Is that what you wanted? Hans |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Have Excel format xxxxxx into date format | Excel Discussion (Misc queries) | |||
| date type format which is supported by excel 2003 | Charts and Charting in Excel | |||
| Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
| Excel enters date as a text format | Excel Discussion (Misc queries) | |||
Threaded Mode
