I want to do a conditional format to make cell A1 have red font if cell B1 is
equal to a certain value (text). Can I do a conditional format on a cell
referencing another cell?

Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=570036

Thank you!!! I just found that answer on another posting. Thank you so much
for your speedy help!!!

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=570036

Dear SteveG

I don't understand how to change the cell value is option to formula is.
Can you explain more specifically ?

Thanks in advance.

Peter

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=570036

Click on the dropdown arrow at FormatCFCondition1 "Cell Value is"


Gord Dibben MS Excel MVP

On Fri, 2 May 2008 15:07:01 -0700, Please explain more specifically <Please
explain more wrote:

Dear SteveG

I don't understand how to change the cell value is option to formula is.
Can you explain more specifically ?

Thanks in advance.

Peter

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=570036

Do you know how to do this in the newest version of Excel? The closest thing
I can find there is an option to decide *which*cell to format based on a
formula, but what I really want to do is use a gradient scale based on value
in a different column. Thanks for your help.

"Gord Dibben" wrote:

Click on the dropdown arrow at FormatCFCondition1 "Cell Value is"


Gord Dibben MS Excel MVP

On Fri, 2 May 2008 15:07:01 -0700, Please explain more specifically <Please
explain more wrote:

Dear SteveG

I don't understand how to change the cell value is option to formula is.
Can you explain more specifically ?

Thanks in advance.

Peter

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=570036

Can you be be more specific? Need more detail.

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
Do you know how to do this in the newest version of Excel? The closest
thing
I can find there is an option to decide *which*cell to format based on a
formula, but what I really want to do is use a gradient scale based on
value
in a different column. Thanks for your help.

"Gord Dibben" wrote:

Click on the dropdown arrow at FormatCFCondition1 "Cell Value is"


Gord Dibben MS Excel MVP

On Fri, 2 May 2008 15:07:01 -0700, Please explain more specifically
<Please
explain more wrote:

Dear SteveG

I don't understand how to change the cell value is option to formula is.
Can you explain more specifically ?

Thanks in advance.

Peter

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=570036

Ok, I was reading and I have the same issue for Excel 2007, I want to
conditionally format a blank cell, based on the % value of another cell. How
do I do that??

Thanks


"Gord Dibben" wrote:

Click on the dropdown arrow at FormatCFCondition1 "Cell Value is"


Gord Dibben MS Excel MVP

On Fri, 2 May 2008 15:07:01 -0700, Please explain more specifically <Please
explain more wrote:

Dear SteveG

I don't understand how to change the cell value is option to formula is.
Can you explain more specifically ?

Thanks in advance.

Peter

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=570036

Select the blank cell..........say A1

Home tabStylesConditional FormattingManage Rules

New RuleUse a Formula to determine............

=B1=50% Format to a fill color and OK


Gord

On Thu, 5 Feb 2009 11:41:04 -0800, Brian
wrote:

Ok, I was reading and I have the same issue for Excel 2007, I want to
conditionally format a blank cell, based on the % value of another cell. How
do I do that??

Thanks


"Gord Dibben" wrote:

Click on the dropdown arrow at FormatCFCondition1 "Cell Value is"


Gord Dibben MS Excel MVP

On Fri, 2 May 2008 15:07:01 -0700, Please explain more specifically <Please
explain more wrote:

Dear SteveG

I don't understand how to change the cell value is option to formula is.
Can you explain more specifically ?

Thanks in advance.

Peter

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=570036

Christine<

In Excell 2007, I want to be able to set a formula for a single cell (c3)
such that it turns red when its numerical contents are =not(a1+b1 = c3) and
the cell turns green when its numerical contents =(a1+b1=c3). How do I set
both of these condiions for a single cell in Excel 2007?

Thanks,

Karen

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=570036

Select cell C3

Goto Home tabStylesConditional FormattingManage Rules

Click New RuleUse a formula to determine...
Format values where this formula is true:
=AND(COUNT(A1,B1,C3)=3,C3<A1+B1)
Click the Format button
Select the desired style(s)
OKOK
Click New Rule again and repeat the above proccess for the second
condition. Use this formula:
=AND(COUNT(A1,B1,C3)=3,C3=A1+B1)

Then, OKOKApplyOK


--
Biff
Microsoft Excel MVP


"KMorris" wrote in message
...
Christine<

In Excell 2007, I want to be able to set a formula for a single cell (c3)
such that it turns red when its numerical contents are =not(a1+b1 = c3)
and
the cell turns green when its numerical contents =(a1+b1=c3). How do I
set
both of these condiions for a single cell in Excel 2007?

Thanks,

Karen

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=570036

Biff,

Thanks, but I'm not clear why the command now needs to include the
AND(COUNT(a1,b1,c3)=3 statement prior to what used to be the =(c3=a1 +b1)
statement.

What are we now telling Excel to do in that first portion of the statement?




"T. Valko" wrote:

Select cell C3

Goto Home tabStylesConditional FormattingManage Rules

Click New RuleUse a formula to determine...
Format values where this formula is true:
=AND(COUNT(A1,B1,C3)=3,C3<A1+B1)
Click the Format button
Select the desired style(s)
OKOK
Click New Rule again and repeat the above proccess for the second
condition. Use this formula:
=AND(COUNT(A1,B1,C3)=3,C3=A1+B1)

Then, OKOKApplyOK


--
Biff
Microsoft Excel MVP


"KMorris" wrote in message
...
Christine<

In Excell 2007, I want to be able to set a formula for a single cell (c3)
such that it turns red when its numerical contents are =not(a1+b1 = c3)
and
the cell turns green when its numerical contents =(a1+b1=c3). How do I
set
both of these condiions for a single cell in Excel 2007?

Thanks,

Karen

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=570036

It means that you won't apply the format unless all 3 cells have values in
them. If the cells (or some of them) are emplty, it won't try to do the
formatting. If you want the CF test doing regardless of blank cells, then
omit that part of the formula.
--
David Biddulph

"KMorris" wrote in message
...
Biff,

Thanks, but I'm not clear why the command now needs to include the
AND(COUNT(a1,b1,c3)=3 statement prior to what used to be the =(c3=a1 +b1)
statement.

What are we now telling Excel to do in that first portion of the
statement?




"T. Valko" wrote:

Select cell C3

Goto Home tabStylesConditional FormattingManage Rules

Click New RuleUse a formula to determine...
Format values where this formula is true:
=AND(COUNT(A1,B1,C3)=3,C3<A1+B1)
Click the Format button
Select the desired style(s)
OKOK
Click New Rule again and repeat the above proccess for the second
condition. Use this formula:
=AND(COUNT(A1,B1,C3)=3,C3=A1+B1)

Then, OKOKApplyOK


--
Biff
Microsoft Excel MVP


"KMorris" wrote in message
...
Christine<

In Excell 2007, I want to be able to set a formula for a single cell
(c3)
such that it turns red when its numerical contents are =not(a1+b1 = c3)
and
the cell turns green when its numerical contents =(a1+b1=c3). How do I
set
both of these condiions for a single cell in Excel 2007?

Thanks,

Karen

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=570036

I'm assuming *all 3 cells* require a numeric entry.

AND(COUNT(A1,B1,C3)=3 makes sure there are in fact 3 numbers in those cells.

If certain combinations of cells are empty without the test for COUNT the
format could be applied. I assume you don't want a cell colored if it's
empty?


--
Biff
Microsoft Excel MVP


"KMorris" wrote in message
...
Biff,

Thanks, but I'm not clear why the command now needs to include the
AND(COUNT(a1,b1,c3)=3 statement prior to what used to be the =(c3=a1 +b1)
statement.

What are we now telling Excel to do in that first portion of the
statement?




"T. Valko" wrote:

Select cell C3

Goto Home tabStylesConditional FormattingManage Rules

Click New RuleUse a formula to determine...
Format values where this formula is true:
=AND(COUNT(A1,B1,C3)=3,C3<A1+B1)
Click the Format button
Select the desired style(s)
OKOK
Click New Rule again and repeat the above proccess for the second
condition. Use this formula:
=AND(COUNT(A1,B1,C3)=3,C3=A1+B1)

Then, OKOKApplyOK


--
Biff
Microsoft Excel MVP


"KMorris" wrote in message
...
Christine<

In Excell 2007, I want to be able to set a formula for a single cell
(c3)
such that it turns red when its numerical contents are =not(a1+b1 = c3)
and
the cell turns green when its numerical contents =(a1+b1=c3). How do I
set
both of these condiions for a single cell in Excel 2007?

Thanks,

Karen

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=570036

Has to be said, Conditional Formatting in Excel 2007, whilst it might offer
more features, is alot more complex and counter-intuitive than in Excel 2003.

Biff,

I'm trying to add an ActiveX control Text Box to a sheet form in Excel 2007.
I can add the ActiveX Text Box control from the Developer menu "Insert" set
of ActiveX choices, and then I can go into properties and set the "Linked"
property to a particular cell in the spreadsheet. This works dandy, as when
I type anything in the "Data," "Text" property within the properties setup, I
see the text populating into the Linked Cell I designated. What has me
totally stumped is that once I close the properties box and go back to the
sheet form, I cannot--as a user--type anything into the text box. Every time
I click on it, the ActiveX box simply behaves as though it is an object. The
point of my putting the text box there is so that users of the form can enter
text for "Other" conditions which canot be captured by other questions on the
form.

How do I get this ActiveX control Text Box to allow Input by the user typing
directly into it? For now, the ActiveX text box seems to be behaving as a
text box formatted for "display only," such as the "Home Phone" text box
label that might be situated next to another text box into which the user CAN
type their home phone number. I need to be able to format this ActiveX text
box so that the user CAN type into it.

Help!

Thanks,

Karen

"T. Valko" wrote:

Select cell C3

Goto Home tabStylesConditional FormattingManage Rules

Click New RuleUse a formula to determine...
Format values where this formula is true:
=AND(COUNT(A1,B1,C3)=3,C3<A1+B1)
Click the Format button
Select the desired style(s)
OKOK
Click New Rule again and repeat the above proccess for the second
condition. Use this formula:
=AND(COUNT(A1,B1,C3)=3,C3=A1+B1)

Then, OKOKApplyOK


--
Biff
Microsoft Excel MVP


"KMorris" wrote in message
...
Christine<

In Excell 2007, I want to be able to set a formula for a single cell (c3)
such that it turns red when its numerical contents are =not(a1+b1 = c3)
and
the cell turns green when its numerical contents =(a1+b1=c3). How do I
set
both of these condiions for a single cell in Excel 2007?

Thanks,

Karen

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=570036

I would like to format A1 with "strikeout" if A3 is 0 (zero). How do I write
that one?

"T. Valko" wrote:

Select cell C3

Goto Home tabStylesConditional FormattingManage Rules

Click New RuleUse a formula to determine...
Format values where this formula is true:
=AND(COUNT(A1,B1,C3)=3,C3<A1+B1)
Click the Format button
Select the desired style(s)
OKOK
Click New Rule again and repeat the above proccess for the second
condition. Use this formula:
=AND(COUNT(A1,B1,C3)=3,C3=A1+B1)

Then, OKOKApplyOK


--
Biff
Microsoft Excel MVP


"KMorris" wrote in message
...
Christine<

In Excell 2007, I want to be able to set a formula for a single cell (c3)
such that it turns red when its numerical contents are =not(a1+b1 = c3)
and
the cell turns green when its numerical contents =(a1+b1=c3). How do I
set
both of these condiions for a single cell in Excel 2007?

Thanks,

Karen

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=570036

You have replies at your other post

--
Biff
Microsoft Excel MVP


"Becky" wrote in message
...
I would like to format A1 with "strikeout" if A3 is 0 (zero). How do I
write
that one?

"T. Valko" wrote:

Select cell C3

Goto Home tabStylesConditional FormattingManage Rules

Click New RuleUse a formula to determine...
Format values where this formula is true:
=AND(COUNT(A1,B1,C3)=3,C3<A1+B1)
Click the Format button
Select the desired style(s)
OKOK
Click New Rule again and repeat the above proccess for the second
condition. Use this formula:
=AND(COUNT(A1,B1,C3)=3,C3=A1+B1)

Then, OKOKApplyOK


--
Biff
Microsoft Excel MVP


"KMorris" wrote in message
...
Christine<

In Excell 2007, I want to be able to set a formula for a single cell
(c3)
such that it turns red when its numerical contents are =not(a1+b1 = c3)
and
the cell turns green when its numerical contents =(a1+b1=c3). How do I
set
both of these condiions for a single cell in Excel 2007?

Thanks,

Karen

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=570036

Hi Steve,

Is there a way of using the conditional formatting method you have mentioned
below but using a different sheet in the workbook...?

I have tried conditionally formatting with 'formula is' using:
=MyWorksheet!$A$1="MyText"

But I get the error "You may not use references to other worksheets......."

Kind Regards,
Colin.

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=570036

HI

I have a similar question to Christine's conditional formatting.

I want to to format all the cells with blue in Column D if Column C has "NA".

Think there shouldnt be an easier way than setting hundreds of lines with =
C1="NA" in every cell in column D.

Many thanks!

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=570036

You can apply the formatting to a range of cells all at one time.

Assume the range you want to format is D1:D100

In Excel 2007

Select the range of cells, D1:D100
Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a
formula to determine which cells to format
Enter this formula in the box below:
=C1="NA"
Click the Format button
Select the desired style(s)
OK out

In Excel versions 2003 and earlier

Select the range of cells, D1:D100
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=C1="NA"
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"CDQ" wrote in message
...
HI

I have a similar question to Christine's conditional formatting.

I want to to format all the cells with blue in Column D if Column C has
"NA".

Think there shouldnt be an easier way than setting hundreds of lines with
=
C1="NA" in every cell in column D.

Many thanks!

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=570036

Bilff

It works! thanks!

"T. Valko" wrote:

You can apply the formatting to a range of cells all at one time.

Assume the range you want to format is D1:D100

In Excel 2007

Select the range of cells, D1:D100
Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a
formula to determine which cells to format
Enter this formula in the box below:
=C1="NA"
Click the Format button
Select the desired style(s)
OK out

In Excel versions 2003 and earlier

Select the range of cells, D1:D100
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=C1="NA"
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"CDQ" wrote in message
...
HI

I have a similar question to Christine's conditional formatting.

I want to to format all the cells with blue in Column D if Column C has
"NA".

Think there shouldnt be an easier way than setting hundreds of lines with
=
C1="NA" in every cell in column D.

Many thanks!

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=570036

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"CDQ" wrote in message
...
Bilff

It works! thanks!

"T. Valko" wrote:

You can apply the formatting to a range of cells all at one time.

Assume the range you want to format is D1:D100

In Excel 2007

Select the range of cells, D1:D100
Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a
formula to determine which cells to format
Enter this formula in the box below:
=C1="NA"
Click the Format button
Select the desired style(s)
OK out

In Excel versions 2003 and earlier

Select the range of cells, D1:D100
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=C1="NA"
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"CDQ" wrote in message
...
HI

I have a similar question to Christine's conditional formatting.

I want to to format all the cells with blue in Column D if Column C has
"NA".

Think there shouldnt be an easier way than setting hundreds of lines
with
=
C1="NA" in every cell in column D.

Many thanks!

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=570036

Steve,

Thank you it worked out, could I make it work for an entire column?
e.g.
Column A heading is "Country" & Column B heading is "Capital", It'd really
be a great help if certian Country's text turns to RED for example once I
type (Or from a list) capital name.

It's quite long the columns my colleagues got to look up frequently.

Ali

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=570036

Thank you for the answer, this has perplexed me for years! Your awesome!

I'm guessing that whoever you directed your message to will probably not
realize it was for them as you posted your thank you message in a brand new
thread rather than responding to the person you wanted to thank back in the
thread where he/she actually helped you at.

--
Rick (MVP - Excel)


"Marque" wrote in message
...
Thank you for the answer, this has perplexed me for years! Your awesome!

I have no idea how to highlight a whole row when I have a set condition.

You see, I need to shade a row of data (8-rows of content), yellow when it
is pending, and I need to turn those rows yellow/italic when the they are NOT
approved, and I have to get those same rows to turn black and Bold when they
ARE approved. How on earth can I get the conditional formating to do that,
and can you dumb it down completely, as I have no clue how to build out
formulas at all.

My data is for what program content has rights -- so I have a wide list of
shows, producers, distributors, etc. All the legal reps will do is indicate
"Y" "N" or "P" in the cell, and then carry on down to the next cell. There
could be hundreds of rows of content... is this even possible???

help please -- I can be reached at or at

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=570036

I have data on rows 1 thru 10,
In column C the data is either "pending" or something else
I clicked the mouse on the 1 for the row header for row 1 and dragged down
to row 10; the first 10 rows are selected

I used Format | Conditional Format in Excel 2003
In Excel 2007 open the Home tab and locate the Styles group and click on
Conditional Formatting | New Rule
Is used Formula Is: =$C1="pending" and clicked the Format button to give
that row a yellow pattern and italic font
The I added another Formula Is: =$C1<"pending" and clicked the Format
button and make the pattern blue with bod font
A test shows this method worked as expected

See also Debra Dalgleish At:
http://www.contextures.com/xlCondFormat01.html
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Gail" wrote in message
...
I have no idea how to highlight a whole row when I have a set condition.

You see, I need to shade a row of data (8-rows of content), yellow when it
is pending, and I need to turn those rows yellow/italic when the they are
NOT
approved, and I have to get those same rows to turn black and Bold when
they
ARE approved. How on earth can I get the conditional formating to do
that,
and can you dumb it down completely, as I have no clue how to build out
formulas at all.

My data is for what program content has rights -- so I have a wide list of
shows, producers, distributors, etc. All the legal reps will do is
indicate
"Y" "N" or "P" in the cell, and then carry on down to the next cell.
There
could be hundreds of rows of content... is this even possible???

help please -- I can be reached at or at


"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=570036

Never mind. Thank you Dave Peterson. Your response to an earlier posting is
exactly what I needed.

"Christine Hemphill" wrote:

I want to do a conditional format to make cell A1 have red font if cell B1 is
equal to a certain value (text). Can I do a conditional format on a cell
referencing another cell?