Holiday Formula for an Employee time sheet

R

RichL

Can anyone help me with writing a formula to conditional
format holidays to change font color on a timesheet.
 
V

Vasant Nanavati

Excel has know way of knowing what the holidays are. If you make a list of
dates that are holidays and name that range "Hoildays", then the conditional
format formula would be:

=NOT(ISNA(MATCH(A1,Holidays,0)))
 
Top