Extend conditional format to other rows

J

Joe M.

I want to change the color of a row's text based upon the value "No" in the
same row. I want to extend this for the other rows on the same sheet. For
example:
If cell D2="No" then text in row 2 is red.
If cell D3="No" then text in row 3 is red.
etc...
The sheet is already filled so I need to apply this formatting afterward.
Can someone help please?
 
D

David Biddulph

Select the rows, from 2 downwards, ensure that your active cell is in row 2,
Format/ Conditional formatting/ Formula is: =$D2="No", and format to red
text.
 
L

Lauren Giles

Oh, it's easy! Kay, select the column (in this case, column D), and go to
Format> Conditional Formatting.

You want [Cell value is] [equal to] [no]. Clickie the format button and
select red as the "pattern." It'll make anything in row D that has the word
"no" change the background to red.
 
G

Gord Dibben

Select all the rows to be CF'd

Format>CF>Formula is: =$D2="No"

Note the $ sign to fix the column D but not the row number.

Format the Font to Red.

Note: do not let Excel change the $D2 to $D$2

Edit if that's the case.


Gord Dibben MS Excel MVP
 
D

David Biddulph

But I think the OP was asking for the whole row to go red, not just the cell
in column D?
Hence my suggestion for using Formula is, rather than Cell value is.
--
David Biddulph

Lauren Giles said:
Oh, it's easy! Kay, select the column (in this case, column D), and go to
Format> Conditional Formatting.

You want [Cell value is] [equal to] [no]. Clickie the format button and
select red as the "pattern." It'll make anything in row D that has the
word
"no" change the background to red.
Click to expand...
 
Top