Conditional Formatting is not applied untill we click 'No Fill' in Excel 2010

Hi Jasper Team and others,

I am using Jasper server 5.0 which generates Excel in .xlsx format.

When I tried to open and apply conditional formatting in Excel 2010, it's not working.

It's applies only when we click 'No Fill'.

Also this generated Excel works good in Excel 2007.

Can anybody suggest me a fix.

Also, I attested a file which is not applying conditional Formatting until we click on 'No Fill' in 'Font' section.

Thanks,

S Atah Ahmed Khan.

May The True God help and bless us.