Cell background colour

chinnu123 — Thu, 12 Nov 2015 23:27:02 GMT

Hi Community,

Here I am facing an issue regarding cell background colour which needs to change to red. where the condition is

Case1:

If field5(Externalsd-8.5%) is greater than field5(Internal-3.2%) then background colour of field5(Externalsd-8.5%) should change to red colour.

Case2: If field5(Inbuild greater than 1.6% then the background colour of field5(Inbuild-1.7%) should be yellow

I am attaching sample excel sheet

Thanks in Advance,

Regards,

Chinnu.

Re: Cell background colour

settu_periasamy — Fri, 13 Nov 2015 02:35:50 GMT

Hi,

Check the below expression in your Background Color of your Expression.

if(Field1='External SD' and sum(Field5)>Sum({<Field1={'Internal'}>}Field5),Red(),

if(Field1='inbuilt' and sum(Field5)>0.016,Yellow(),White()))

check the attachement