excel 2010 change color of a cell based on th

January 28, 2011 at 15:56:45
Specs: Windows XP
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


See More: excel 2010 change color of a cell based on th

Report •


#1
January 28, 2011 at 17:34:22
Try this:

         A                B
1) Current Milage    Maintenance Due
2)    46003              51115
3)    50959              51115

Conditional 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 Red

MIKE

http://www.skeptic.com/


Report •

#2
February 1, 2011 at 10:50:26
Where does C1 come into play?

Report •

#3
February 1, 2011 at 12:00:23
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

Report •

Related Solutions

#4
February 1, 2011 at 17:47:17
Where does C1 come into play?

My error:

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

MIKE

http://www.skeptic.com/


Report •

#5
February 1, 2011 at 17:48:34
dreiter, please post your question in a separate thread.

MIKE

http://www.skeptic.com/


Report •

#6
February 2, 2011 at 15:48:08
I am going to work on this document tomorrow and will let you know how things go. Thank you!

Report •


Ask Question