Share via

Is there a way to pull through holiday dates (annual leave) for the next 4 weeks onto another sheet

Anonymous
2025-01-30T12:22:14+00:00

Morning All,

I have a task tracker which has all my master data on one page ('Tracker' sheet) and then pulls through the current days tasks onto the front page ('Today' sheet).

I have decided it would be a good idea to track my holidays as well in case I need to move or amend any tasks so have marked some days in row 5 on the Tracker sheet with 'H'. I was wondering if there is a way to display any dates that have a 'H' in them on the front page, the following 4 weeks from the current date would be ideal.

I would also like to turn the column green if I have marked it as a holiday, so for example column P on the Tracker sheet is marked with 'H, is there a way to then turn column P green based on that fact?

Here is a test page I have been working on to show what I currently have:

Tracker - Test Page (1).xlsx

Many Thanks,

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

HansV 462.6K Reputation points
2025-01-30T12:40:50+00:00

See Tracker-Test-Page-1.xlsx

I had to unmerge the area.

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2025-01-30T13:18:29+00:00

    Hello HansV,

    Thats perfect, thanks so much for your help! :)

    Kind Regards,

    Was this answer helpful?

    0 comments No comments