Highlighting Multiple cells when changing one cell value

Copper Contributor

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? 

1 Reply

@kran2512 

=$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