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

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

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