ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Date and Formatting (https://www.excelbanter.com/excel-worksheet-functions/251605-date-formatting.html)

RaY

Date and Formatting
 
Thanks for the help with the other formulas on my last thread but I still
can't get my "in between" formatting to work. I want the date entered into
A1 to change color when the computer calendar is 21 to 28 days after the date
entered. Thanks.

Fred Smith[_4_]

Date and Formatting
 
What did you try?
What results did you get?
What version of Excel are you using?
What color do you want it changed to?
Is the color different for 21 days than it is for 28 days?

You're not making it easy for people to help when you post ambiguous
questions. It looks like you're asking everyone else to do the work when
you're not willing to do any.

Post back with specifics so people can get you a definitive answer rather
than trying to guess what you want.

Regards,
Fred

"Ray" wrote in message
...
Thanks for the help with the other formulas on my last thread but I still
can't get my "in between" formatting to work. I want the date entered
into
A1 to change color when the computer calendar is 21 to 28 days after the
date
entered. Thanks.



RaY

Date and Formatting
 
I am using microsoft office 2007.

I am using the following formulas:
Green - =(TODAY()-A1<=20) This formula does what I want i.e.
change green when the cell is less than or equal to 20 days after the date
entered.

Yellow - =(TODAY()-A120),(TODAY()-A1<=28) This formula does NOT
do what I want i.e. change yellow when the cell is between 21 and 28 days
after the date entered.

Red - =(TODAY()-A128) This formula does what I want i.e. change
red when the cell is greater than 28 days after the date entered.

I hope this helps.

"Fred Smith" wrote:

What did you try?
What results did you get?
What version of Excel are you using?
What color do you want it changed to?
Is the color different for 21 days than it is for 28 days?

You're not making it easy for people to help when you post ambiguous
questions. It looks like you're asking everyone else to do the work when
you're not willing to do any.

Post back with specifics so people can get you a definitive answer rather
than trying to guess what you want.

Regards,
Fred

"Ray" wrote in message
...
Thanks for the help with the other formulas on my last thread but I still
can't get my "in between" formatting to work. I want the date entered
into
A1 to change color when the computer calendar is 21 to 28 days after the
date
entered. Thanks.


.


Ashish Mathur[_2_]

Date and Formatting
 
Hi,

Change to this

=and((TODAY()-A120),(TODAY()-A1<=28))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Ray" wrote in message
...
I am using microsoft office 2007.

I am using the following formulas:
Green - =(TODAY()-A1<=20) This formula does what I want i.e.
change green when the cell is less than or equal to 20 days after the date
entered.

Yellow - =(TODAY()-A120),(TODAY()-A1<=28) This formula does NOT
do what I want i.e. change yellow when the cell is between 21 and 28 days
after the date entered.

Red - =(TODAY()-A128) This formula does what I want i.e. change
red when the cell is greater than 28 days after the date entered.

I hope this helps.

"Fred Smith" wrote:

What did you try?
What results did you get?
What version of Excel are you using?
What color do you want it changed to?
Is the color different for 21 days than it is for 28 days?

You're not making it easy for people to help when you post ambiguous
questions. It looks like you're asking everyone else to do the work when
you're not willing to do any.

Post back with specifics so people can get you a definitive answer rather
than trying to guess what you want.

Regards,
Fred

"Ray" wrote in message
...
Thanks for the help with the other formulas on my last thread but I
still
can't get my "in between" formatting to work. I want the date entered
into
A1 to change color when the computer calendar is 21 to 28 days after
the
date
entered. Thanks.


.


Gord Dibben

Date and Formatting
 
=AND(TODAY()-A220,TODAY()-A2<=28)


Gord Dibben MS Excel MVP


On Tue, 22 Dec 2009 15:08:01 -0800, Ray
wrote:

I am using microsoft office 2007.

I am using the following formulas:
Green - =(TODAY()-A1<=20) This formula does what I want i.e.
change green when the cell is less than or equal to 20 days after the date
entered.

Yellow - =(TODAY()-A120),(TODAY()-A1<=28) This formula does NOT
do what I want i.e. change yellow when the cell is between 21 and 28 days
after the date entered.

Red - =(TODAY()-A128) This formula does what I want i.e. change
red when the cell is greater than 28 days after the date entered.

I hope this helps.

"Fred Smith" wrote:

What did you try?
What results did you get?
What version of Excel are you using?
What color do you want it changed to?
Is the color different for 21 days than it is for 28 days?

You're not making it easy for people to help when you post ambiguous
questions. It looks like you're asking everyone else to do the work when
you're not willing to do any.

Post back with specifics so people can get you a definitive answer rather
than trying to guess what you want.

Regards,
Fred

"Ray" wrote in message
...
Thanks for the help with the other formulas on my last thread but I still
can't get my "in between" formatting to work. I want the date entered
into
A1 to change color when the computer calendar is 21 to 28 days after the
date
entered. Thanks.


.



David Biddulph[_2_]

Date and Formatting
 
But you don't need the 20 condition, because you've already tested for <=20
=(TODAY()-A1<=28) would do.
--
David Biddulph

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
=AND(TODAY()-A220,TODAY()-A2<=28)


Gord Dibben MS Excel MVP


On Tue, 22 Dec 2009 15:08:01 -0800, Ray
wrote:

I am using microsoft office 2007.

I am using the following formulas:
Green - =(TODAY()-A1<=20) This formula does what I want i.e.
change green when the cell is less than or equal to 20 days after the date
entered.

Yellow - =(TODAY()-A120),(TODAY()-A1<=28) This formula does NOT
do what I want i.e. change yellow when the cell is between 21 and 28 days
after the date entered.

Red - =(TODAY()-A128) This formula does what I want i.e. change
red when the cell is greater than 28 days after the date entered.

I hope this helps.

"Fred Smith" wrote:

What did you try?
What results did you get?
What version of Excel are you using?
What color do you want it changed to?
Is the color different for 21 days than it is for 28 days?

You're not making it easy for people to help when you post ambiguous
questions. It looks like you're asking everyone else to do the work when
you're not willing to do any.

Post back with specifics so people can get you a definitive answer
rather
than trying to guess what you want.

Regards,
Fred

"Ray" wrote in message
...
Thanks for the help with the other formulas on my last thread but I
still
can't get my "in between" formatting to work. I want the date entered
into
A1 to change color when the computer calendar is 21 to 28 days after
the
date
entered. Thanks.

.






All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com