How to have rows change color depending on value in a certain cell?

Highlighted
Occasional Contributor

I need to have a row change color if I have a O entered into it to change yellow and C would change it to green. Is this possible?

3 Replies
Highlighted

@Sergei Baklan 

 

I need to fill in the whole row with the specific color is one of the cells has a O or C, not just the cell.

Highlighted

@CarterDRH , as @Sergei Baklan pointed out, use conditional formatting. Here's an example for the first 30 rows:

 

TheAntony_0-1595282988477.png