Cell colors or text color changing when date in cell gets closer.

G

Guest

My problem is this; I have a mutiple page worksheet that will have a lot of
dates. What I need for inspection purposes is a formula that when each date
gets closer either the cell or the text changes color. I need to have
hi-lighted when that date is getting within 90 days, 60 days, 30 days and
when it expires. I can maybe do without the last one of expiration if the
under 30 days one stays bright red after expiring. I.e. a person's visa
expiration is in Feb 07. When that date is within 90 days, I need it to alert
me. Then again within 60 days with a new color, 30 days with a new color and
etc.
Do I have to have a seperate column or adjacent cell of any sort to make
this happen?

American Perplexed in Afghanistan
 
G

Guest

This is a matter of Conditional formatting (Format/Conditional formatting) !
See XL Help for details, it's easy!

Regards,
Stefi

„Chase†ezt írta:
 
G

Guest

Thank you but, I already understand that it is conditional formatting. I also
understand it is probably possible. But, there is nothing explaining it in
excel help. I have been through Excel help for two days and watched even the
tutorials. I do not see the formulas for which I am having trouble.
 
G

Guest

If dates are in column A (suppose a heading in A1) then select the range
required, formulas for conditional formatting are:

1. =A2-TODAY()<0 expired
2. =A2-TODAY()<30 within 30 days
3. =A2-TODAY()<60 within 60 days


The problem is that XL allows only 3 conditions, so there is no space for
case within 90 days, you have to think it over!

Regards,
Stefi


„Chase†ezt írta:
 
G

Guest

Thank you Stefi. You are a gem.



Stefi said:
If dates are in column A (suppose a heading in A1) then select the range
required, formulas for conditional formatting are:

1. =A2-TODAY()<0 expired
2. =A2-TODAY()<30 within 30 days
3. =A2-TODAY()<60 within 60 days


The problem is that XL allows only 3 conditions, so there is no space for
case within 90 days, you have to think it over!

Regards,
Stefi


„Chase†ezt írta:
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell color changes when date gets closer 2
Conditional Formating for dates beyond 30, 60, 90 to be high light 3
Date Turns Green 90-Days before the date shown in cell 7
add color or picture to a cell using a formula 2
changing cell background colors with formulas 5
Changing the colour of a cell after a specific date? 0
Changing text color of certain "word" in cell 3
Experation Date 2

Top