Top Ten highlights all

J

James

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
 
B

Barb Reinhardt

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top