Conditional formatting a full row triggered by a single cell

  • Thread starter Thread starter neilcarden
  • Start date Start date
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 Re
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

Thank
Nei
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional formatting update issue 5
conditional format of entire row based on a single cell in row 7
Conditional Formatting 3
Creating a reader bar with Conditional Formatting 1
Conditional Formatting for entire row 4
Conditional formatting a cell containing "<" 4
Excel Conditioning Formatting 3
Conditional format a column based on value in a different column 3

Back
Top