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
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