Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.