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