Cell background colour

[chinnu123]

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.

[settu_periasamy · Accepted solution]

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