I want to chage a whole rows text color based on single cell valu.

I am trying to change the text color of multiple cells based on the value of
one cell

You can do this with Conditional Formatting. Other than that, I think
you'll need a macro.

Regards

Trevor


"thediamondfam" <thediamondfam@discussions.microsoft.com> wrote in message
news:647752DD-671B-423C-BCEC-B1FABE8826C2@microsoft.com...
>I am trying to change the text color of multiple cells based on the value
>of
> one cell

Select row or cells to Format.

Then Format>Cells>Formula is =$A1=1

Pick a font color from the Format dialog and OK your way out.

NOTE: the dollar sign($) in $A1 must be entered.

$A1=1 would of course be adjusted to your preferred cell and value.


Gord Dibben Excel MVP

On Tue, 11 Jan 2005 15:03:03 -0800, "thediamondfam"
<thediamondfam@discussions.microsoft.com> wrote:

>I am trying to change the text color of multiple cells based on the value of
>one cell

I have this same problem. I want to use conditional formatting to check a particular cell, and based on the value of that cell change the format of the entire row it's in. I don't want to use a macro, but I don't really understand the post before this one. When I go to Format --> Cells --> There is no place to put a formula. There's got to be a way to do it under format --> Conditional Formatting. I want to select the entire spreadsheet, and if the value in column H is "y" then I want to change the color. How can I do this?

Hi,

Try this:
1. Select Conditional Formatting
2. Change leftmost text From 'Cell Value Is' To 'Formula Is'
3. Write you condition formula. Example: =A1=A2

Ola

Thanks for dumbing it down for me. I got it to work exactly how I wanted