Conditional formatting a full row triggered by a single cell
 

Hi everyone,

I'm wondering is it possible to (conditional) format say a row of 8
consecutive cells based on the value of seperate single cell? and if
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 the
cell where the yes or no would be.

Thanks
Neil

Yes, all you have to do is make sure the $ are around the cell you are
referencing. For example if you have your "Yes" or "No" values located in
cell A1, the conditional formatting formulas would be:

=IF($A$1="Yes",TRUE,FALSE)

and make the formatting of this condition green. Likewise:

=IF($A$1="No",TRUE,FALSE)
and make the formatting of this condition red.

When you copy the formatting of this cell down to others the cell reference
will stay focused on A1.
--
Regards,

DaveB


"neilcarden" wrote:

Hi everyone,

I'm wondering is it possible to (conditional) format say a row of 8
consecutive cells based on the value of seperate single cell? and if
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 the
cell where the yes or no would be.

Thanks
Neil