SOLVED

For a word: (Use a formula to determine which cell to format)

Copper Contributor

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?

 

NoraJJ_0-1674758850732.png

 

2 Replies
best response confirmed by NoraJJ (Copper Contributor)
Solution

@NoraJJ 

=$C1="e. Completed"

You can try this rule for conditional formatting.

=$A:$D

This is the range the formatting applies to in the example.

conditional formatting e. Completed.JPG 

Putting the 1 after C was the fix I needed! Thank you for that.

1 best response

Accepted Solutions
best response confirmed by NoraJJ (Copper Contributor)
Solution

@NoraJJ 

=$C1="e. Completed"

You can try this rule for conditional formatting.

=$A:$D

This is the range the formatting applies to in the example.

conditional formatting e. Completed.JPG 

View solution in original post