Conditional formatting help?

[cornflks1979]

Hello, my first time posting a thread up here so if you don't understand what I am asking for I will and try to explain better.

So I have dates in my worksheet going from H2:M2. The dates are at random intervals. How can I make that cell turn green when it comes within the month of that date in those cells? Then turn red once it hits the exact date or goes over in those cells?

I am not sure if I explained it ver good but if you have any questions about this you can let me know and I can send you the worksheet I have and try to explain it better then. Thanks for the help.

Mark

 

[wolverineb]

If you know how to do conditional formatting in general, you would choose "formula is" and enter something like this:

=MONTH(H2)=MONTH(TODAY())

and format green

then do same thing but with a less than sign before the second MONTH
and format red

 

[hilyete]

If you want the dates within the present month (but less than today)to turn green, and today's date and greater (of the same month), to turn red try these:

In the conditional formatting create 2 separate formulas:

=(OR(H2=(TODAY()),AND(MONTH(H2)=MONTH(TODAY()), DAY(H2)>(DAY(TODAY())))))

set for Green

=(AND(MONTH(H2)=MONTH(TODAY()), DAY(H2)<(DAY(TODAY()))))

Set for Red