Look at conditional formatting.
--
David Biddulph

"fatdave" wrote in message
...
OK.

I have got about 100 cars that I am responcible for making shour that they
get services on time. Ther are two types of services.

1) Done every 21 days
2) Done on millage.

I have got a if statyment then tels me in a collounm if it is over due,
that
was not that hard. What I would like to be able to do is if the cell
changes
to a yes then turn it red so that it stands out. I would also like to
chand
the cell to yellow when it is getting within 3 day of a service or getting
with in 500 miles.

Any ider if this is possable and if it is how would I do thisn.

Thanks

Dave