Enter the background color according to the conditions.

[Paknanarn23]

Want to add a background color to the condition that if the count comes out and there are 2 consecutive values, the shift will be red. But if not, make it yellow.

This is the code that does the counting.

if(Shift='Morning',Count(
DISTINCT IF(
NOT WildMatch(AD_Remark, '*ok*', '*ปกติ*', '*down*')
AND AD_ApproveStatus <> '1',
AD_Remark
)
)
,
if(Shift='Afternoon',Count(
DISTINCT IF(
NOT WildMatch(AD_Remark, '*ok*', '*ปกติ*', '*down*')
AND AD_ApproveStatus <> '1',
AD_Remark
)
)
,
if(Shift='Night',Count(
DISTINCT IF(
NOT WildMatch(AD_Remark, '*ok*', '*ปกติ*', '*down*')
AND AD_ApproveStatus <> '1',
AD_Remark
)
)
)))