ExcelBanter - Holiday Formula for an Employee time sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Holiday Formula for an Employee time sheet (https://www.excelbanter.com/excel-programming/283818-holiday-formula-employee-time-sheet.html)

RichL

Holiday Formula for an Employee time sheet

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

Vasant Nanavati

Holiday Formula for an Employee time sheet

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)))

--

Vasant

"RichL" wrote in message
...
Can anyone help me with writing a formula to conditional
format holidays to change font color on a timesheet.

All times are GMT +1. The time now is 07:47 AM.