Forum Discussion
Solved
For a word: (Use a formula to determine which cell to format)
THE ASK: If Column C has "e. Completed" in a row, I need the whole row from A to D columns to turn light green. Could you help me figure out what I've done wrong using the photo below? ...
=$C1="e. Completed"You can try this rule for conditional formatting.
=$A:$DThis is the range the formatting applies to in the example.
=$C1="e. Completed"You can try this rule for conditional formatting.
=$A:$DThis is the range the formatting applies to in the example.
Putting the 1 after C was the fix I needed! Thank you for that.
