Forum Discussion
null null
Sep 01, 2018Copper Contributor
conditional formatting
I'm trying to highlight the lowest 10 scores out of 20 for my golf handicap. I used conditional formatting rule "Format only top or bottom values" and I used Bottom with the value 10 as the ranking v...
himan.shu0501
Sep 02, 2018Copper Contributor
Dear If possible, try to increase the decimal value of the numbers. In case there is a number 86 as a round off figure then you can increase the decimal places. By this some values, will become like 85.90, 85.88 etc. Hence excel will be able to decipher. In case, the no. is strictly 86 then it has to give equal respect to same value while applying sort ascending or descending, In such a case, conditional formatting will not be able to pick 10 counts rather will pick the condition and will give a count nearest to 10. In your case, that's 12 you said. So according to me it won't change automatically and may require manual intervention. Thanks.
Philip West
Sep 02, 2018Iron Contributor
Here is one way to do it.. i have created some helper rows that add some numbers behind the decimal and then using those helper cells to in the formula for the formating.