I keep a log of dates that people receive financial assistance which is in
effect for 365 days. After 365 days they must renew their application.
Currently, I manually look for dates that are 365 days old and change the
text to red. I would like to find a formula that would do this for me.

Use conditional formatting.
--
David Biddulph

"bmcaf12345" wrote in message
...
I keep a log of dates that people receive financial assistance which is in
effect for 365 days. After 365 days they must renew their application.
Currently, I manually look for dates that are 365 days old and change the
text to red. I would like to find a formula that would do this for me.

I looked at conditional formatting and it showed true and false rather than
changing the text color. I am not sure how to do that part. I still want it
to show the date.

"David Biddulph" wrote:

Use conditional formatting.
--
David Biddulph

"bmcaf12345" wrote in message
...
I keep a log of dates that people receive financial assistance which is in
effect for 365 days. After 365 days they must renew their application.
Currently, I manually look for dates that are 365 days old and change the
text to red. I would like to find a formula that would do this for me.

Conditional formatting doesn't show true or false.

Read the help again, and if you are still struggling come back to us and
tell us step by step what you tried.
--
David Biddulph

"bmcaf12345" wrote in message
...
I looked at conditional formatting and it showed true and false rather than
changing the text color. I am not sure how to do that part. I still want
it
to show the date.

"David Biddulph" wrote:

Use conditional formatting.
--
David Biddulph

"bmcaf12345" wrote in message
...
I keep a log of dates that people receive financial assistance which is
in
effect for 365 days. After 365 days they must renew their application.
Currently, I manually look for dates that are 365 days old and change
the
text to red. I would like to find a formula that would do this for me.

I must have been looking at something else for the true & false. Thanks.

In conditional formatting, I put if the cell is greater than or equal to
="today-365", then in the formatting I made the font red. It did not work
but, I am stuggling with how to phrasing it correctly. Thanks in advance for
your help.

"David Biddulph" wrote:

Conditional formatting doesn't show true or false.

Read the help again, and if you are still struggling come back to us and
tell us step by step what you tried.
--
David Biddulph

"bmcaf12345" wrote in message
...
I looked at conditional formatting and it showed true and false rather than
changing the text color. I am not sure how to do that part. I still want
it
to show the date.

"David Biddulph" wrote:

Use conditional formatting.
--
David Biddulph

"bmcaf12345" wrote in message
...
I keep a log of dates that people receive financial assistance which is
in
effect for 365 days. After 365 days they must renew their application.
Currently, I manually look for dates that are 365 days old and change
the
text to red. I would like to find a formula that would do this for me.

You don't want the quote marks around "today-365" as that makes it look for
the text string "today-365".
Also, if you look in Excel help for the TODAY function you'll see that the
syntax is TODAY(), and the parentheses are an essential part of the syntax.
So try replacing ="today-365" by =TODAY()-365
--
David Biddulph

"bmcaf12345" wrote in message
...
I must have been looking at something else for the true & false. Thanks.

In conditional formatting, I put if the cell is greater than or equal to
="today-365", then in the formatting I made the font red. It did not work
but, I am stuggling with how to phrasing it correctly. Thanks in advance
for
your help.

"David Biddulph" wrote:

Conditional formatting doesn't show true or false.

Read the help again, and if you are still struggling come back to us and
tell us step by step what you tried.
--
David Biddulph

"bmcaf12345" wrote in message
...
I looked at conditional formatting and it showed true and false rather
than
changing the text color. I am not sure how to do that part. I still
want
it
to show the date.

"David Biddulph" wrote:

Use conditional formatting.
--
David Biddulph

"bmcaf12345" wrote in message
...
I keep a log of dates that people receive financial assistance which
is
in
effect for 365 days. After 365 days they must renew their
application.
Currently, I manually look for dates that are 365 days old and
change
the
text to red. I would like to find a formula that would do this for
me.

All functions, including those that have no parameter, need parentheses.
When you want today's date, you must use =Today(). Also, ditch the quotes
(they designate you have text, not a formula). Try:

=today()-365

Regards,
Fred.

"bmcaf12345" wrote in message
...
I must have been looking at something else for the true & false. Thanks.

In conditional formatting, I put if the cell is greater than or equal to
="today-365", then in the formatting I made the font red. It did not work
but, I am stuggling with how to phrasing it correctly. Thanks in advance
for
your help.

"David Biddulph" wrote:

Conditional formatting doesn't show true or false.

Read the help again, and if you are still struggling come back to us and
tell us step by step what you tried.
--
David Biddulph

"bmcaf12345" wrote in message
...
I looked at conditional formatting and it showed true and false rather
than
changing the text color. I am not sure how to do that part. I still
want
it
to show the date.

"David Biddulph" wrote:

Use conditional formatting.
--
David Biddulph

"bmcaf12345" wrote in message
...
I keep a log of dates that people receive financial assistance which
is
in
effect for 365 days. After 365 days they must renew their
application.
Currently, I manually look for dates that are 365 days old and
change
the
text to red. I would like to find a formula that would do this for
me.

You're close. try this

=today()-365
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"bmcaf12345" wrote:

I must have been looking at something else for the true & false. Thanks.

In conditional formatting, I put if the cell is greater than or equal to
="today-365", then in the formatting I made the font red. It did not work
but, I am stuggling with how to phrasing it correctly. Thanks in advance for
your help.

"David Biddulph" wrote:

Conditional formatting doesn't show true or false.

Read the help again, and if you are still struggling come back to us and
tell us step by step what you tried.
--
David Biddulph

"bmcaf12345" wrote in message
...
I looked at conditional formatting and it showed true and false rather than
changing the text color. I am not sure how to do that part. I still want
it
to show the date.

"David Biddulph" wrote:

Use conditional formatting.
--
David Biddulph

"bmcaf12345" wrote in message
...
I keep a log of dates that people receive financial assistance which is
in
effect for 365 days. After 365 days they must renew their application.
Currently, I manually look for dates that are 365 days old and change
the
text to red. I would like to find a formula that would do this for me.

Trying again. The first post never showed up. You are quite close, actually.

=TODAY() - 365
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"bmcaf12345" wrote:

I must have been looking at something else for the true & false. Thanks.

In conditional formatting, I put if the cell is greater than or equal to
="today-365", then in the formatting I made the font red. It did not work
but, I am stuggling with how to phrasing it correctly. Thanks in advance for
your help.

"David Biddulph" wrote:

Conditional formatting doesn't show true or false.

Read the help again, and if you are still struggling come back to us and
tell us step by step what you tried.
--
David Biddulph

"bmcaf12345" wrote in message
...
I looked at conditional formatting and it showed true and false rather than
changing the text color. I am not sure how to do that part. I still want
it
to show the date.

"David Biddulph" wrote:

Use conditional formatting.
--
David Biddulph

"bmcaf12345" wrote in message
...
I keep a log of dates that people receive financial assistance which is
in
effect for 365 days. After 365 days they must renew their application.
Currently, I manually look for dates that are 365 days old and change
the
text to red. I would like to find a formula that would do this for me.

Try greater than or equal to

=TODAY()-365

"bmcaf12345" wrote:

I must have been looking at something else for the true & false. Thanks.

In conditional formatting, I put if the cell is greater than or equal to
="today-365", then in the formatting I made the font red. It did not work
but, I am stuggling with how to phrasing it correctly. Thanks in advance for
your help.

"David Biddulph" wrote:

Conditional formatting doesn't show true or false.

Read the help again, and if you are still struggling come back to us and
tell us step by step what you tried.
--
David Biddulph

"bmcaf12345" wrote in message
...
I looked at conditional formatting and it showed true and false rather than
changing the text color. I am not sure how to do that part. I still want
it
to show the date.

"David Biddulph" wrote:

Use conditional formatting.
--
David Biddulph

"bmcaf12345" wrote in message
...
I keep a log of dates that people receive financial assistance which is
in
effect for 365 days. After 365 days they must renew their application.
Currently, I manually look for dates that are 365 days old and change
the
text to red. I would like to find a formula that would do this for me.