Holiday Formula for an Employee time sheet

  • Thread starter Thread starter RichL
  • Start date Start date
R

RichL

Can anyone help me with writing a formula to conditional
format holidays to change font color on a timesheet.
 
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)))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Conditional Formatting to write Text Value only if true 4
Bargain The Sun '£9.50' Holidays 6
Rosh Hashanah and Yom Kippur 3
Add-in WITH worksheets?? 1
Lookup and Enter Value to Other Tab on Change in Cell 0
Referencing cell numbers in a formula 3
Need help with a formula 4
error with countif formula on when adding linked spreadsheets 0

Back
Top