Hello. I have a spreadsheet that highlights dates in a calendar based on the event category, but I have only figured out how to do it with each category in a different column (see sheet 'Columns').
What I need to have is the same information but in a list and have conditional fomatting be able to choose the color based on the category entered in one column next to the event date (see sheet 'List'). I have spent hours trying to find something to help me figure this out and I'm just stuck. Please help me.
Highlighting Dates in a Calendar.xlsx
Bookmarks