Conditional formatting a full row triggered by a single cell reference...

N

neilcarden

Hi everyone,

I'm wondering is it possible to (conditional) format say a row of
consecutive cells based on the value of seperate single cell? and i
so, how would i do it?

ie if the cell was "No" then the row would have background colour Red
and if the cell was "Yes" then the row would turn green.

I've tried to use the conditional format tool, but it just changes th
cell where the yes or no would be.

Thanks
Nei
 
M

Morrigan

Say A1 is your reference cell, try the following:

Highlight B1:J1
Conditional Formatting
Formula is -> =A1="Yes" (Green)
Formula is -> =A1="No" (Red)
 
Top