Hi Eva,

Can't fully understodd your question.

supposed that in Column A = Date of Course booked ,Column B = Expirey date,
Column C=Remark
if A2 = 2003/12/25,
then at B2 =date(year(a1)+3,month(a2),day(a2) which is 2006/12/25
at C2 =if(b2=today(), "expired", if(datedif(today(),b2,"MD")=3, "warning",
""))

If you want cell b2 have conditional formating, then you can set:
"formula is" =c2="warning"

Bobocat

"Eva" wrote in message
...
How do you creat a conditional format for a group of dates containing
dates
of a course booked and then in another column with the expirey date of
either
3 years or 1095 days and then in another colum set a condition to give 3
months warning before the expirey date and can I just select the column
with
that information using e.g A$ ?? if I sent the cell value to be 1095
days(the
whole column as the couse will always need refreshing after 3 years
--
Eva


"bobocat" wrote:

supposed that the column A contain the date,
Select Column A
condition formating
Formula is =and(a1<today(),isblank(a1)=false))

"KAT" ...

Thanks - this works! How can i get it to ignore the blank cells? Thanks
again
for the help.

"bobocat" wrote:

try to select the cell
in conditional formating
"Cell Value is" less than =today(), then set format

"KAT" ...

How do I apply conditional formatting to highlight dates that are
less
than
todays date (today's date should automatically update to the current
days
date) Hope this makes sense. It is for purposes of highlighting
expired
qualifications. Any advice would be appreciated.

Regards,