Forum Discussion
Conditional formatting using colors
I have a calendar that tracks my time worked, holiday, vacation, absent, sick pay and 1/2 day worked. I have been able to conditionally format cells in the calendar that will turn to a specified colo...
For example for W (Worked):
=8*(COUNTIF(P4:BN20, "W")+COUNTIF(P36:BN50, "W"))
and for 1/2V:
=4*(COUNTIF(P4:BN20, "1/2V")+COUNTIF(P36:BN50, "1/2V"))
HansVogelaar Thanks so much. This worked out perfectly! I really appreciate your solution.