|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