Filip, please use the "Post REPLY" button, not the "New Topic" button. (I've just merged this with your old topic again).

Anyway, after mucking around with conditional formatting for 30 minutes I realise that it's probably not going to achieve what you need in conjunction with the VBA code I have given you.

So, add the following (red) lines into your code...
Code:
If AlarmdateMonth = Month(Now) Then
If AlarmdateDay = Day(Now) Then
MsgBox "Today is one month prior to " & Alarmdate, vbInformation, "Alarm"
Cells(10, 5).Select
With Selection.Interior
.ColorIndex = 3
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End If
End If
This will turn your date cell background color RED whenever the condition that raises the alarm message box is met.