Jan 26 2023 10:49 AM
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?
Jan 26 2023 11:02 AM
Solution=$C1="e. Completed"
You can try this rule for conditional formatting.
=$A:$D
This is the range the formatting applies to in the example.
Jan 26 2023 11:28 AM
Putting the 1 after C was the fix I needed! Thank you for that.
Jan 26 2023 11:02 AM
Solution=$C1="e. Completed"
You can try this rule for conditional formatting.
=$A:$D
This is the range the formatting applies to in the example.