Conditional Formatting

**Michelle1234** · 06-14-2010, 04:30 PM

I am trying to create a conditional format that highlights a cell when the one above it is higher. So U12 should be highlighted when U13 is higher, I also need to create a second one when U13 is higher than U12.
If anyone could help that would be greatly appreciated.

**NBVC** · 06-14-2010, 04:36 PM

You basically said the same thing twice....

but I assume you meant the reverse....

so...

Select U12 and invoke Conditional Formatting

Cell Value Is >> Greater than >> =U13

click Format and choose from Pattern tab.

Click Ok... click Ok to exit.

Select U13 and repeat with Cell Value >> Greater than >> =U12

**Michelle1234** · 06-15-2010, 08:30 AM

Except the entire U row needs to have the same conditional formatting, so, U14 would be highlighted if it is less than U15 (in red) and in blue if its higher, with a 10% grace. So if U15 is 125 then U14 would be red if it was 113 or less and blue if it was 137 or higher, except the problem lies with the fact that U15 will not always be 125.

**NBVC** · 06-15-2010, 08:53 AM

10% of 125 is 12.5, so I think 113 would not cause red, but 112.5 and lower would... correct??

So select column U range and invoke CF, then choose Formula Is and enter:

=U1<=U2-U2*0.1

where U1 is top most cell in your selection and U2 is directly below.

then click Format and choose red.

Click Ok.

Click Add and repeat with:

=U1>=U2*1.1

and choose Blue.