Quote:
Originally Posted by CRAIGJACK
hello i wonder if you could help?
i have a date in Cell E3 and i would like it to be highlighted yellow if todays date is 30 days near to the date in E3?
thanks
|
Dear
CRAIGJACK, Good Morning.
As you said,
E3 is your date cell.
E3 =
11/05/2010 (mm/dd/aaaa)
Current date (today) is
10/05/2010 (mm/dd/aaaa)
The function
=TODAY() shows up the current date.
I suggest you to use
Conditional Formatting to follow your desired rules.
DO:
The rule there will be implemented:
...... 1) If the cell
E3 is
Greater or Equal than Current DATE, AND
Less than 30 days from now, then Cell Background turns to
Yellow (you can choose the color you want)
How to do
Conditional Formatting:
...... Click on
E3
.......... Menu -
Format -
Conditional Formatting
When the dialog box appears,
DO:
Condition 1: First field:
The formula is
.................... Second field: type:
=AND((E3-TODAY())<=30,(E3-TODAY())=0)
Button: Format and choose the
background color you like(eg.
YELLOW).
Once you've finished it :
OK
It´s working.
Try to put diferent dates on E3 to test the change of background colors
Feel free to do any questions about it.