A user has a spreadsheet that tracks the current miles on the vehicle, has another column that shows when preventative maintenance needs to be done. What they want is to turn the current miles cell red when it is 90% to needing the preventative maintenance so it's easy to pick out of the list.

I know I need to use Conditional Formatting, Highlight Cells Rule and then More Rules in Excel 2010 and also that I should choose "Use a formula to determine which cells to format" but am not sure what formula to use.

Please provide examples for the formula.

Here is an example of the mileage information:

Current mileage 50,959 Preventative maintenance due at 51,115

Thank you in advance for your assistance

Try this: A B 1) Current Milage Maintenance Due 2) 46003 51115 3) 50959 51115Conditional Format Column A using the formula:

=IF((A1/C1)*100>=90,TRUE,FALSE)

Cell A2 should remain your default color (White)

Cell A3 should turn RedMIKE

Where does C1 come into play?

I have a similar problem, I need want to enter the letters I, D and P in cells and have the cells change to yellow, green and blue, respectively. Please help with the conditional formatting required to do this. Thanks

Where does C1 come into play?My error:

=IF((A2/B2)*100>=90,TRUE,FALSE)

=IF((A3/B3)*100>=90,TRUE,FALSE)MIKE

I am going to work on this document tomorrow and will let you know how things go. Thank you!

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History