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?