Murali Krishna
New Member
Hi,
I have recently upgraded to office 2013. I'm trying to conditional formatting based on the achievement percentage of sales. Below is the criteria
>= 100% - Green
>=95% to 100% - Yellow
<95% - Red
But some how the formatting is not working. I'm attaching the sample sheet with the workings. Request experts to help where I'm going wrong.
Thanks & Regards,
Murali
I have recently upgraded to office 2013. I'm trying to conditional formatting based on the achievement percentage of sales. Below is the criteria
>= 100% - Green
>=95% to 100% - Yellow
<95% - Red
But some how the formatting is not working. I'm attaching the sample sheet with the workings. Request experts to help where I'm going wrong.
Thanks & Regards,
Murali