Date plus 3 years and set to red

Use this to get the 3-years-later date (with your starting date in A1):

Formula:

Please Login or Register  to view this content.

To turn the cell red if it's less than today, do this:
1. Select your range (the range you want to format).
2. On the Home tab of the ribbon, click 'Conditional Formatting', then 'New Rule', then 'Use a formula to determine which cells to format'.
3. In the formula box, enter this (replace 'A2' with the top-left cell of the range you selected at step 1):

Formula:

Please Login or Register  to view this content.

4. Click 'Format' then choose Red fill.
5. Click OK twice to get back to the worksheet.

Hope that helps.

Okay, I see what you want. I thought you wanted a new cell with the 3-years-later date, but you want the cell with the original date to turn red if it's more than 3 years ago.
To do this, you need to include the EDATE in the Conditional Formatting (CF) formula.

Here's the instructions again, updated for that:

1. Select your range (the range you want to format) - probably F8:J13 (assuming the 'First Aid' currency is also 3-yearly).

If that's not the case, then do first column F, then columns H:J.

2. On the Home tab of the ribbon, click 'Conditional Formatting', then 'New Rule', then 'Use a formula to determine which cells to format'.
3. In the formula box, enter this:

Formula:

Please Login or Register  to view this content.

The first part stops blank cells from turning red; the second part checks if the date plus three years is less than today.
You can change the number of years by changing the '36' - it's the number of months.
Change F8 to the top-left of your range, if necessary.

4. Click 'Format' then choose Red text (or fill or whatever you want).
5. Click OK twice to get back to the worksheet.

I've attached your file with this working for the range F8 to J13.

Hope that helps.

You're welcome, glad to be of help.

If you're satisfied that your question has been answered, then please take a moment to mark the thread as Solved so others know there's an answer here (instructions are in my sig). Thanks.