Need a formula to flag a cell

G

Greeneyez2

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?
 
V

VBA Noob

Try this

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Select text from a point given to a specific word 2
Is there a way to create a "flag" in Excel 2007? 5
Add a set number to a random entered number 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Checking Series for Anomalies 1
What will work best here 5
Cell data entering slow! 0
Copy addition formula of non-consecutive horizontal cells 2

Top