Hi @KimLamNg thank you very much for your response to my question. I did give try using this process but unable to arrive at the desired results. Hence i thought i could explain my question via example. In the attached excel file contains the attendance list where column A represent employee name and remaining date columns represent whether the employee is present for that day. If the dates column contain and "X" for respective employee then it represents that the employee was present for that particular day. Now what i am trying to find is an conditional formatting where the date header turns red when all the employees are absent for that particular day. Please do provide your guidance.
