Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
copteral
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
Dav
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
copteral
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
flummi
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
copteral
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Have Excel format xxxxxx into date format Teri Excel Discussion (Misc queries) 3 February 15th 06 08:53 PM
date type format which is supported by excel 2003 kanchan Charts and Charting in Excel 2 September 21st 05 11:56 PM
Format date in excel 2000 like '31st January 2005' Malcolm Agingwell Excel Discussion (Misc queries) 4 July 14th 05 03:39 PM
Excel 2000 date format cannot be set to Australian date format Brian Jones Excel Discussion (Misc queries) 1 March 30th 05 06:03 AM
Excel enters date as a text format Kane Excel Discussion (Misc queries) 3 March 22nd 05 10:20 PM


All times are GMT +1. The time now is 01:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"