A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
I had to unmerge the area.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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:
Many Thanks,
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
Answer accepted by question author
Hello HansV,
Thats perfect, thanks so much for your help! :)
Kind Regards,