Forum Discussion

Sara1713's avatar
Sara1713
Copper Contributor
May 13, 2022

Need help with conditional formatting

As background I am trying to create a document to make it easy for employees to sign up for “split shifts”.  My desire is that when two employees put their names in Column B and Column C that those ...
  • Sara1713 

     

    Suppose you want to apply the conditional formatting to the range B4:C20 then select the range B4:C20 and make the new conditional formatting rules using the formulas given below...

     

    For Orange:

    =AND(COUNTA($B4:$C4)=2,D4="")

     

    For Green:

    =AND(COUNTA($B4:$C4)=2,$D4<>"")

Resources