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

Copper 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

@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.

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

 

TheAntony_0-1595282988477.png