Hi Guys, if someone could help I would be most grateful.

My problem is:

I have a sheet of course names in columns C to V.

Names of personnel down the left in column A with cels 6&7 merged, 8&9
merged, an so on. (Only column A has been merged in this way)

Each course has under it a completed and expires date. ie column c,
completed c6 and expires c7.

Column B just has COM and EXP below it beside each name to identify the dates

The date format is dd/mm/yy

What I would like is for the the expirey date to flag up a month in advance
with say the colour red.

Does that make any sense to anyone? I hope so.