Conditional Formatting Using Multiple Values in Other Data Validation Cells

I've been researching this formula problem for several hours, and need some help:

I am working an employee schedule that has time formulas used to calculate hours worked. I have created a "Note" column next to each hours scheduled (HR) column to identify when an employee takes a vacation (VAC) holiday (HOL) or safety day (SFT). These are pulled from a Data Validation list located on the same spreadsheet but in different cells (on my sheet they are AF1:AH1). I need these hours to calculate and add to the total, but do not want the employees to see a "scheduled" shift (the manager would still need to enter a "ghost shift" for the time calculation to function however). My thought was to conditionally format the time entry cells so whenever "HOL", "VAC", or "SFT" is selected from the "Note" drop down list, the scheduled times font would appear and print in white and thus be invisible. What formula could I use in Conditional Formatting that would make this work?

Example of appearance after conditional formatting applied:

IN OUT HR NOTE
5.0 HOL
8:30 AM 1:30 PM 5.0
8:30 AM 1:30 PM 5.0
8:30 AM 1:30 PM 5.0



Thanks,
UCLAID

Sorry. Example appearance formatting did not keep. Let's try again:


excel image.jpg

Example image is still not right (you'd think it was a Monday). It got the white text right, but turned all the other time cells black. I have no idea why.

I figured it out with one of the ugliest formulas I've ever come up with:

=OR($E$8=$AF$1)=OR( $E$8=$AG$1)=OR( $E$8=$AH$1).

Not elegant, but it works.