Conditional Formatting 3 date frames with a RAG Status

[Toodlelou]

Hi All,
I have a 'Planned Date' column (V) and I need to apply the following conditional formatting RAG status:

• Four weeks prior to date in column 'V' the date needs to be highlighted Green
• Between 3 and 2 weeks prior to date in column 'V' the date needs to be highlighted Amber
• 1 week or less prior to date in column 'V' the date needs to be highlighted Red

I have tried various CF rules and various formulae but cannot get the results I require. Please help?
Many thanks and kindest regards,
Toodle

 

[Toodlelou]

They all come back as TRUE

 

[Special-K99]

Attach a sample spreadsheet with expected results, remove any sensitive data.
You cant attach files on this forum.
Upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[paulunh11]

#1 Excel tutorial on the net - Excel Easy

 

[Toodlelou]

Thank you Special-K99

We have decided just to apply conditional formatting to the cells that show what is due in the next week. Which I can do!

Thank you again for your help