R RichL Nov 28, 2003 #1 Can anyone help me with writing a formula to conditional format holidays to change font color on a timesheet.
Can anyone help me with writing a formula to conditional format holidays to change font color on a timesheet.
V Vasant Nanavati Nov 28, 2003 #2 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)))
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)))
