Forum Discussion
Sara1713
May 13, 2022Copper Contributor
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 ...
- May 14, 2022
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<>"")
Sara1713
May 14, 2022Copper Contributor
Thank you that worked perfectly!!
Subodh_Tiwari_sktneer
May 14, 2022Silver Contributor
You're welcome Sara1713! Glad it worked as desired.