Conditional Formatting For a Specific Date

[RangerE51]

I am making a tracker to track events and how close we are to the next time the event has to be done. Specifically the event has to be done every 6 (180 days) months. I am looking for a conditional format formula that can color code when certain days have been hit. When it is less then 30 days or less from the next event color it yellow, when 31-180 color it green and anything past due color it red.



Using todays date as an example 12-Feb-15 it would be colored green. 150-179 days from now I would need it to be colored yellow. Anything beyond 180 days from now would need to be red.

If I haven't made it clear let me know and I will try and restate it.

[orange]

So what exactly is your question?

Have you researched Conditional Formatting?
Have you tried to create a sample database and conditional formatting?

What exactly have you done so far? Can you show us something?
Have you tried query(s) to select the records you need?

[A S MANN]

in the report design ,for the Select the date field use conditional format property .
eg format 1 [Date]<150 Format colour Green
format 2 [Date]Between 150 And 179 Format colour yallow
format 3 [Date]>=180 Format colour Red