Conditional formatting trouble

[SamBramz]

Hi Everyone,

Firstly, I can’t thank this community enough for the resources offered here – its brilliant!

Im having some trouble with Google sheets, I want to do something relatively simple but I have no clue! What I would like to do is highlight the entire row based on the option I choose in column C.

https://www.screencast.com/t/Rm9IX3DD51

So far, I have used conditional formatting to colour the boxes in column C, based on my selected option (leave them alone, send video, etc). But I don’t know how to do it for the entire row. I need the entire row to be highlighted based on the option chosen.

Can anyone help?

 

[Marcelo Branco]

Welcome to Mr Excel forum

I've no experience with Google sheets but in Excel to highlight the row you should use a formula.

Suppose the data are in, say, A2:D10 and you do want to highlight A2:D2; A3:D3 etc if C2; C3 etc is equal to "send video"

Select all the data: A2:D10
go to Home > Conditional formatting > New rule
pick the last option (Use a formula to determine...)
Insert this formula (observe the $)
=$C2="send video"
Format button and pick the format you want (Fill --> green, for example)
Ok, Ok

Done!

Hope this helps

M.