Agents absence & attendance schedule - final (1).xlsx
This is not what I mean my friend.
I mean if the value in any cell in the range of B4:AF4 equal to friday or saturday, I want to make its column in the range of this column highlighted in another color.
I did it manually and want to do it with conditional format.