K kumartrp New Member Jan 6, 2019 #1 I am conditional formatting applied but is error only 1st year only Its more than 5% its ↑ symbols but its running ok but a 1st year more than 5% its showing ↓ symbol Attachments FORMATE COND.xls 29.5 KB · Views: 3
I am conditional formatting applied but is error only 1st year only Its more than 5% its ↑ symbols but its running ok but a 1st year more than 5% its showing ↓ symbol
P Peter Bartholomew Well-Known Member Jan 6, 2019 #2 Your conditional format identified the lowest 5% of the NPRatios rather than any NPRatio with a value less than 0.05. Attachments FORMATE COND (PB).xls 30 KB · Views: 5
Your conditional format identified the lowest 5% of the NPRatios rather than any NPRatio with a value less than 0.05.
