Format a whole row based on value of one cell

  • Thread starter Thread starter gfroese
  • Start date Start date
G

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
 
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
 
Back
Top