Format a whole row based on value of one cell

[gfroese]

I want to use conditional formatting to colour a whole row of cell
based on the value in column C.

I understand how conditional formatting works on the single cell yo
select, but I don't know how to change the format for multiple cell
based on the value of a single cell.

Any suggestions?
g

 

[Frank Kabel]

Hi
try the following as an example:
- select row 1
- goto 'format - Conditional Format'
- choose 'formula' and enter the following formula
=$C1=your_value
- choose a format

 

[gfroese]

Thanks Frank, that worked