Need a formula to flag a cell

[Guest]

I have a vehicle maintenance worksheet with a row for each vehicle. In one
cell I have the mileage, in another I have a cell with a text box that has
the mileage of last oil change. Is there a formula to flag a cell if the
current mileage is 3000 more than the number in the text box?

 

[Guest]

You can do that with Conditional formatting, available on the FORMAT menu.

 

[VBA Noob]

Try this

=IF(C4-B4>3000,"<<< Warning - Veh has exceeded Oil Change by
&C4-B4-3000& " miles. Please arrange service !!",""

 

[Guest]

I'm very new at this... how would I insert it? In Visual Basic?

 

[VBA Noob]

I assumed you meant cell ref not a text box.

I also assumed cell C4 had current mileage and B4 has mileage of las
oil change. In cell D4 copy the foumla in.

Change cell reference as required