I need to create an IF THEN rule in this calendar in Excel. The rule I need is IF any text is placed in cell next to Overline: then no text can be placed in cell next to Sky Box: (or vice versa). And I need the same rule for Strip: and Jewel: It would be phenomenal if once text is placed, the other box is automatically grayed out. Does anyone know how to do something like that?
HI Tori
Please see attached file and screenshots
Combination of data validation and conditional formatting will sort the issue.
