Formatting a row

[blooneptune]

Hello,

I want an entire row to be highlighted by a chosen color based on the contents of a cell. E.g. If a cell in column K=yes, format entire row with a color.
Thanks in advance

 

[Norie]

Select the entire row(s), goto Format>Conditional Formatting..., select formula is, enter this formula

=$K1="Yes"

and format as required.

Note change 1 in the formula to reflect the first row of data.

 

[blooneptune]

Thank you. Works great.