View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Greeneyez2
 
Posts: n/a
Default 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?