Help with if formual please!!!!! Im so lost!! Take a look!!!

[jroyer2308]

Im trying to make a tacker fro all my works training that we do, an example is below, the dates are when they did the training, and theh months are the frequency of the training.




A B C D E F G H

what im trying to do is use conditional formatting to turn the dates yellow when they are within 60 days of renewal and red when they are within 30. To me it makes sense but then again im not very good with any of this. I see it as this imagine the first block is A1

=IF(C3+670>TODAY()) I want it to turn yellow and =IF(C3+700>TODAY()) i want it red. I need it for all this dates, and some have differnt frequencys of training.

so obviously this isn't correct or i wouldn't be here.

CAN ANYONE OFFER ME HELP AND EXPLAIN TO ME HOW TO DO THIS? I AM EAGER TO LEARN EXCEL!!!!

 

[baitmaster]

Hi I can't see the image on your post, but I'm guessing this should help. Conditional formatting doesn't need the IF statement, it just needs the criteria =c3+670>today()

 

[jroyer2308]

Hi I can't see the image on your post, but I'm guessing this should help. Conditional formatting doesn't need the IF statement, it just needs the criteria =c3+670>today()

THANK YOU FOR YOUR REPLE!!! i tried your formula but nothing happens....


here is an example, let say all these are 12 month re-certifications

2/18/11
6/25/11
9/4/11
5/5/2012
7/7/2012

so on 12/18/12 i want that box to turn yellow

4/25/12 i want the box to turn yellow, and so on and so on for the rest

but on 1/18/2012 i want the box to turn red(idicating thy are month from being over due)

IS THERE A FORMULA FOR THIS? IF SO PLEASE HELP!!!

 

[jroyer2308]

Hi I can't see the image on your post, but I'm guessing this should help. Conditional formatting doesn't need the IF statement, it just needs the criteria =c3+670>today()

bump!!

 

[baitmaster]

try the following conditional formatting on cell C3:
condition 1: =TODAY()-C3>335 (1 year -30 days), format red background
condition 2: =TODAY()-C3>275 (1 year -90 days), format yellow background

 

[jroyer2308]

i copied and pasted what you inputed but it wont let that work in the formula. do you have any other help?

 

[jroyer2308]

try the following conditional formatting on cell C3:
condition 1: =TODAY()-C3>335 (1 year -30 days), format red background
condition 2: =TODAY()-C3>275 (1 year -90 days), format yellow background

copied and pasted what you inputed but it wont let that work in the formula. do you have any other help?