Hello,
I have a spreadsheet going with several tabs and each tab represents 1 week. In each tab, I have a drop down column with 2 options: booked and tentative (in a given week, we can only book 5 events max). I currently have it set so that if it is tentative, the cell becomes red and if it is booked, the cell becomes green. I would also like to have the tab colour change with the following parameters: if all 5 dates are booked, the tab becomes green. If any of the 5 dates are tentative, the tab becomes red. Wondering if anyone can assist?
I have a spreadsheet going with several tabs and each tab represents 1 week. In each tab, I have a drop down column with 2 options: booked and tentative (in a given week, we can only book 5 events max). I currently have it set so that if it is tentative, the cell becomes red and if it is booked, the cell becomes green. I would also like to have the tab colour change with the following parameters: if all 5 dates are booked, the tab becomes green. If any of the 5 dates are tentative, the tab becomes red. Wondering if anyone can assist?