Help with Conditional Formatting...

[PaulHudgins]

I have been working on this but have not been able to figure it out so far. Basically I have numeric values set in rows and I need to compare the values to a certain cell in that row and then highlight the other cells in the row if they are greater than 10% of the numeric value of the reference cell.

So for instance: C4 contains the reference value and E4 to K4 need to be highlighted if they are 10% greater than the numeric value in C4.

Thank you,

Paul Hudgins

[NBVC]

use formula for conditional format after selecting E4:K4

=E4>1.1*$C4

[daddylonglegs]

So if C4 is 50 you want to highlight E4 if it's more than 10% of that (greater than 5) or more than 10% higher than that value (greater than 55)?

Select E4:K4 and try this formula in conditional formatting for the former

=E4>$C4*10%

...or for the latter

=E4>$C4*110%