Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to filter on highlights? | Excel Discussion (Misc queries) | |||
how do i lock in highlights for every other row in excel | Excel Worksheet Functions | |||
duplicated in two worksheets with highlights | Excel Discussion (Misc queries) | |||
cursor highlights everything | Excel Discussion (Misc queries) | |||
Printing Highlights? | Excel Discussion (Misc queries) |