Quote:
Originally Posted by Mazzaropi
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.
|
Ok thank you,
but now what if there are mutiple dates in Column E?
will the formula be:
=AND((E$3$-TODAY())<=30,(E$3$-TODAY())=0) ?
Similar Threads
Threaded Mode
