Hi,

If I've understood correctly yo have an expiry date in column b that you
want to turn (say) red a month before that date. Select your dates and this
assumes they begin in B1 and then:-

Format|conditional format.
Select formula is and paste this in and pick a colour
=AND(B1-TODAY()=0,B1-TODAY()<=30)

Mike

"Sibbs" wrote:

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.