Changing a cell colour
 

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

Changing a cell colour
 

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

Changing a cell colour
 

You can do that with Conditional formatting.
Say
column A B C D
Next service day Next service mileage Present mileage Notices
Formula in column D:
=IF(OR(A2<TODAY(),B2-C2<0),"overdue",IF(OR(A2<TODAY()+3,B2-C2<500),"warning",""))

Select column D
Format/Conditional formatting
1st condition: Cell value equals overdue, choose red color as Format
2nd condition: Cell value equals warning, choose yellow color as Format

Regards,
Stefi

€žfatdave€� ezt Ã*rta:

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