View Single Post
  #2   Report Post  
Mazzaropi Mazzaropi is offline
Senior Member
 
Location: Belo Horizonte, Brazil
Posts: 170
Thumbs up

Quote:
Originally Posted by CRAIGJACK View Post
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.
__________________
I hope it can help you.

Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil

Last edited by Mazzaropi : October 5th 10 at 03:15 PM