Conditional formating

Closed
ROB_L Posts 1 Registration date Tuesday August 19, 2014 Status Member Last seen August 19, 2014 - Aug 19, 2014 at 07:13 PM
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 - Aug 21, 2014 at 06:43 PM
I am working on a spreadsheet that tracks vehicles preventive maintenance.

I would like the Mileage Last PM was performed (A1) to turn red when the Month Ending Mileage (B2) exceeds the last PM mileage by 10000. There are several trucks I have to do this for and would like to carry the formatting from A1-A70.

1 reply

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Aug 21, 2014 at 06:43 PM
ROB_L, Good evening.

Select A1.
Menu Conditional Formatting.
New Rule.
Using Formulas.

=B2>=A1+10000
....Choose RED as fill cell.
OK

Apply to $A$1:$A$70

This rule does exactly what you asked for.

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0