Changing the colour of selected cells based on a single value

How can I change the cell colour of a selection based on the value in a certain cell?

For example, if a value in a certain cell in row 102 is "1" I want the whole row 102 to be green, if it is "0" then the whole row to go red. See image attached.
2017-02-24_14-10-37.png

Two ways to accomplish this :

#1 Include the row range in the Conditional Fomatting A102:Z102 or what ever is the last column used beyond Z.

#2 Conditional Format for C102 (your pic is small so hard to tell which Column). Then use the Format Paint Brush on the entire row.

That doesn't help much. I know it can be done with Conditional Formatting is some way, but I need instructions how to do so.

Example that can be done on any cell/row

Enter a 1 in cell C8

Left Click cell / Conditional Formatting / New Rule / Use A Formula To Determine Which Cells To Format

Paste this formula into the formula field =$C8=1

Click Format Color & choose color

Click Ok

Back at worksheet now -

Click cell C8 / Format Painter (on Home Tab)

Now have marching ants around C8

Click in A8 and hold / drag as far right as desired. Lift left mouse button.

All of row 8 now highlighted.

If you want to apply the same rule to other rows you can :

- highlight the row with color

- copy and paste to another row

or
- with the row highlghted, click and hold on the small button lower right corner
of highlighted area, then drag down as far as needed.

- anytime a 1 is entered into a cell in Column C, that row will be highlighted.

You can change the number 1 in the formula for anything that you are tracking which causes the row
to change color.

Originally Posted by Logit

Example that can be done on any cell/row

Enter a 1 in cell C8

Left Click cell / Conditional Formatting / New Rule / Use A Formula To Determine Which Cells To Format

Paste this formula into the formula field =$C8=1

Click Format Color & choose color

Click Ok

Back at worksheet now -

Click cell C8 / Format Painter (on Home Tab)

Now have marching ants around C8

Click in A8 and hold / drag as far right as desired. Lift left mouse button.

All of row 8 now highlighted.

If you want to apply the same rule to other rows you can :

- highlight the row with color

- copy and paste to another row

or
- with the row highlghted, click and hold on the small button lower right corner
of highlighted area, then drag down as far as needed.

- anytime a 1 is entered into a cell in Column C, that row will be highlighted.

You can change the number 1 in the formula for anything that you are tracking which causes the row
to change color.

Excellent! Very thourough instructions. Thank you for your help!
2017-02-27_13-03-58.png

You are welcome.

Cheers