Mar 09 2022 06:38 AM
I am trying to have multiple cells highlighted when I change the status of one cell to "updated". For example, I changed cell C3 to "updated" from a drop down list I created and I need cells D3, D4, G3,G4 to be highlighted when I make that change. Can someone assist with what formula I should use?
Mar 09 2022 06:50 AM
=$C$3="updated"
You can enter this rule for conditional formatting and apply the conditional format to range:
=$D$3:$D$4;$G$3:$G$4