SONJOE JOSEPH
Member
Dear All,
I am attaching an excel file and i need a conditional formula were the colors should come according to the colors shown in the excel sheet. I have been using this formula =AND(B5<$B$4,B5<>"") but found that its not given the correct colors in some of the values.
Can somebody correct the formula
Regards,
Sonjoe
I am attaching an excel file and i need a conditional formula were the colors should come according to the colors shown in the excel sheet. I have been using this formula =AND(B5<$B$4,B5<>"") but found that its not given the correct colors in some of the values.
Can somebody correct the formula
Regards,
Sonjoe