Conditional formatting a specific date

Question

hi all total novice here,

I'm try to conditional format date to show red if it's 12 months after the date that's entered in column A, so if its 25/05/2024 entered it will turn red on 25/5/25. thanks

Answer 1

hi all total novice here,

I'm try to conditional format date to show red if it's 12 months after the date that's entered in column A, so if its 25/05/2024 entered it will turn red on 25/5/25. thanks

thanks Martin, sorry it didnt work.

Does anyone know a conditional format for this.

if 25/5/24 is entered in column A1 and the date in A2 is 12 months in advance of that, i want a formula to turn A2 red, when it hits the date in A1, if that makes sense

thanks

Answer 2

Hi,

Click on the cell you want to apply the conditional formatting. Go to the Home tab on the ribbon > Conditional Formatting > New rule > "Use a formula to determine which cells to format" and then type this:

=DATEDIF($A$1;$B$1;"M")>12

Then choose to fill with the color you'd like.

Assuming your first date is on A1 and the second one on B1.

Cheers,

Martin