You were very close...
First condition (red format)
=TODAY()-A1365

Second condtion (yellow format)
=TODAY()-A1300

Think of this as being "The distance between today and the date in A1 is
more than x days"

--
Best Regards,

Luke M
"Simon" wrote in message
...
Dear All,

I am looking for some help formatting cells with date entries using excel
2003.
I have tried using 'formula is' and '=(A1-TODAY())<300', and have seen
variations on this theme in other threads, but don't seem to be able to
get a
formula to work with the following;

Date entered into cell (not necessarily 'todays' date). Cell turns yellow
when 300 days have elapsed from the date entered, cell turns red when 365
days have elapsed from the date entered

(I have the cells formatted for date)

Grateful for any help. Thanks.