In Excel, conditional format (font red) referencing another cell?

[Guest]

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?

 

[SteveG]

Christine,

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

=B1="Your Text"

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

HTH

Stev

 

[Guest]

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

 

[Guest]

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

 

[Please explain more specifically]

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

 

[Gord Dibben]

Click on the dropdown arrow at Format>CF>Condition1 "Cell Value is"


Gord Dibben MS Excel MVP

 

[Steve]

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.

 

[T. Valko]

Can you be be more specific? Need more detail.

 

[KMorris]

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

 

[T. Valko]

Select cell C3

Goto Home tab>Styles>Conditional Formatting>Manage Rules

Click New Rule>Use 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)
OK>OK
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, OK>OK>Apply>OK

 

[KMorris]

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?

 

[David Biddulph]

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.

 

[T. Valko]

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?

 

[KMorris]

David,

Thanks. Is there a particular edition of an instructional book for Excel
2007 that you would recommend? I wasn't real thrilled with the one I had for
Excel 2003, but at least the Help facility in Excel 2003 was a whole lot
better than the Help facility within Excel 2007. Thank God you and others
here are so helpful.

Karen

 

[David Biddulph]

No. I'm still using 2003.
--
David Biddulph

David,

Thanks. Is there a particular edition of an instructional book for Excel
2007 that you would recommend? I wasn't real thrilled with the one I had
for
Excel 2003, but at least the Help facility in Excel 2003 was a whole lot
better than the Help facility within Excel 2007. Thank God you and others
here are so helpful.

Karen

 

[KMorris]

David,

You're using an instructional book for Excel 2003 to use Excel 2007? I find
the functionalities to be very different, e.g., one never had to have Excel
count the cells and make sure thre was something in each each in order to get
conditiobal formatting to work.
Maybe I didn't understand your meaning.

Thanks,

Karen

 

[David Biddulph]

No. I'm still using Excel 2003. What I have read on this group hasn't
encouraged me to change.

 

[KMorris]

David,

I'm not keen on using Excel 2007 either. However, I have a client who has
already made the switch-over to Excel 2007, and I would like to get my hands
on a well-written manual for Excel 2007 (the Help section is not as good as
in Excel 2003) and also be able to recommend something specific that staff
here consider purchasing in order to have a reference tool when using Excel
2007.

Thanks,

Karen

 

[KMorris]

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

 

[Colin]

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.