| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time calculations for Scheduled vs Actual Employee Time and Wages | Excel Discussion (Misc queries) | |||
| Time calculations for Scheduled vs Actual Employee Time and Wages | Excel Discussion (Misc queries) | |||
| Employee login time sheet | Excel Discussion (Misc queries) | |||
| Employee Time Sheet | Excel Worksheet Functions | |||
| I need an Excel bi-weekly employee time sheet template | Excel Discussion (Misc queries) | |||
Linear Mode
