Hi , Can anyone help...i am putting conditional formatting in excel. While using formula to remove NA and putting 0% conditional formatting not work. It highlight the value in green and red both color. While i want <5.0% should be in green color and >5.1% will be red color.