Capacity calendar using a lookup and conditional formatting?

[khalinguyen191999]

I have a simple capacity table which houses contact names down one side and days of the week across the top.

I'd like the cells to go red if that contact is busy on a specific day, or go green if they are free... easy enough.

However, this is an outlook for 2-3 weeks from the current week. The data of which is stored in a separate sheet, not within a set range of cells (these cells will change depending on the increase/decrease of demand).

Is it possible to lookup IF date is 2 or 3 weeks from current week, match with the contact name(s) in the table and display the free/busy output in green/red?

[bebo021999]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.