color on cell

[capriconuser]

i have table like this

e.g.

employeename   dates 20/3/2017  21/3/2017 22/3/2017 23/3/2017

abc employee                 5:00               5:00     5:00                    -

defemployee                        -                 5:00     5:00                    -

xyz employee                    5:00                  -       5:00                    -

now here i want to try if all employees has '-' on then want to color  beacuse on 23 suppose to be official holiday

this is i try but not works ..

=if(count({<AbsentFlag = {'Absent'}>}ZID) = $(vTotalEmp),RGB(0,0,255))

this fill cells where they found absent where as i want when all employees have absent then want to color on that specific date not all dates

[vishsaggi]

IF you scroll to the right on my earlier reply you can see the expression I used. I sent you a snapshot.

Scroll to the right you can see the expression.