Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conditional format a date in Excel
I am trying to use conditional formatting to show when a date is less than 30
days in the future. When I use "cell value" "is less than" "="Now()+30" all the dates change. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conditional format a date in Excel
I am trying to use conditional formatting to show when a date is less than 30 days in the future. When I use "cell value" "is less than" "="Now()+30" all the dates change. lose the quotes in the condition =Now()+30 Unless you mean between today and 30 days in the future in which case =now() would be the first condition and =now()+30 would be the second Also now() returns the date and time is this what you require often today() which just returns the date is preferable Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=513696 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conditional format a date in Excel
Thanks for the quick response, actually, the Excel (computer) puts the quotes
in. I did finally find a Discussion from 2004 that helped also by using Today() instead of Now() and got it to work. Al "Dav" wrote: I am trying to use conditional formatting to show when a date is less than 30 days in the future. When I use "cell value" "is less than" "="Now()+30" all the dates change. lose the quotes in the condition =Now()+30 Unless you mean between today and 30 days in the future in which case =now() would be the first condition and =now()+30 would be the second Also now() returns the date and time is this what you require often today() which just returns the date is preferable Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=513696 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conditional format a date in Excel
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 |
#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 |
Reply |
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) |