Top Ten highlights all
 

Hello All,

I am trying to use the top ten conditional formatting across approxmately
150 items.

Some of the numbers appear below (they are all in the same row in the
spreadsheet):

-0.0005 1.6014 -0.0010 -0.0227 -0.0003 0.0004 -0.0639 0.0009 0.0968 0.8518 -0.2478 -0.0931 0.0035 0.0412 -0.0027 0.0000 -0.0672

And come from a formula like this one:

=(OFFSET(B$12,-6,0)/OFFSET(B$12,-7,0))*100-100

When I use the top ten all the numbers are highlighted. Anybody know why?

Other conditional formatting (like numbers greater then zero) work fine.
Conditional formatting top ten on another worksheet works fine as well.

Thanks,

James

Top Ten highlights all
 

1) What do you have set for your conditional format?
2) How are you determining the top 10?


"James" wrote:

Hello All,

I am trying to use the top ten conditional formatting across approxmately
150 items.

Some of the numbers appear below (they are all in the same row in the
spreadsheet):

-0.0005 1.6014 -0.0010 -0.0227 -0.0003 0.0004 -0.0639 0.0009 0.0968 0.8518 -0.2478 -0.0931 0.0035 0.0412 -0.0027 0.0000 -0.0672

And come from a formula like this one:

=(OFFSET(B$12,-6,0)/OFFSET(B$12,-7,0))*100-100

When I use the top ten all the numbers are highlighted. Anybody know why?

Other conditional formatting (like numbers greater then zero) work fine.
Conditional formatting top ten on another worksheet works fine as well.

Thanks,

James