Need a formula to flag a cell
 

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?

Need a formula to flag a cell
 

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


"Greeneyez2" wrote:

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?

Need a formula to flag a cell
 

Try this

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


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=553821

Need a formula to flag a cell
 

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

"VBA Noob" wrote:


Try this

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


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=553821

Need a formula to flag a cell
 

I assumed you meant cell ref not a text box.

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

Change cell reference as required.


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=553821