Creating IF THEN rules in Excel

Question

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&nbsp;Overline:&nbsp;then no text can be placed in cell next to&nbsp;Sky Box:&nbsp;(or vice versa). And I need the same rule for&nbsp;Strip:&nbsp;and&nbsp;Jewel:&nbsp;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?

tomasz kocur · Answer

HI Tori&nbsp;&nbsp;Please see attached file and screenshots&nbsp;Combination of data validation and conditional formatting will&nbsp;sort the issue.&nbsp;&nbsp;&nbsp;

Forum Discussion

Creating IF THEN rules in Excel

Share

Resources