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?

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.
--
David Biddulph

"Joe M." wrote in message
...
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?

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.

"Joe M." wrote:

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?

Select all the rows to be CF'd

FormatCFFormula 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

On Wed, 7 Mar 2007 07:55:26 -0800, Joe M.
wrote:

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?

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" wrote in message
...
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.

"Joe M." wrote:

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?