Conditional Formatting Vacation Tracker

[aroesch]

Excel newbie here...

I am trying to conditionally format an excel calendar based on multiple criteria. I have the calendar on one worksheet and a table with a list of time taken off on another worksheet.

I was able to use the MATCH function to compare the dates in the holidays table with the dates in the calendar, but I am not sure how to nest the MATCH function with other criteria. I think I need to use the AND function with MATCH but I am unsure how to combine the two functions.

I tried to combine using the formula below to highlight the calendar blue on vacation days (should be 10/19), but it didn't seem to work.

=AND(MATCH(B6,'2020 PTO Tracker'!$B$5:$B$15,0)>0,'2020 PTO Tracker'!$C$5:$C$15>0)

Can someone tell me what I am doing wrong?

 

[DRSteele]

Welcome to the forum.

I have a lot of trouble trying to figure out formulas from a picture like the one you posted. If you upload that portion of your spreadsheet with the xl2bb tool [see link in my signature below], it would be easier for someone to help you.