Changing a cell colour

F

fatdave

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
 
S

Stefi

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:
 
Top