Formula needed please...

[Freddie]

I need a formula that will do the following:
If a letter entered into cell A1 is the same as the letter already in cell
A10 then change the text colour in A10.
Is this possible?
I'm using Excel 2007
Many thanks for any replies.

 

[Nick Hodge]

Freddie

You need to look at conditional formatting, in the styles group on the home
tab

Click in A10 and then invoke the menu command, select 'new rule' and then
'Format only cells that contain'. Select 'Cell value' 'Equal to' and click
on A1 (this will give you =$A$1). Select a format for the text

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[Freddie]

Hi Nick, Many thanks for the quick response, but this doesn't seem to work
for me, maybe I'm doing it wrong?

 

[Nick Hodge]

Freddie

Do you get =$A$1 in the box alongside the 'Equal to' in the dropdown? (To
check, click in A10 and then take the conditional formatting option and
select manage rules... and edit).

I have presumed that the value in A1 *In it's entirety* matches A10, e.g
there is a single N in both cells for example.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[Freddie]

Freddie

Do you get =$A$1 in the box alongside the 'Equal to' in the dropdown?
Yes
(To
check, click in A10 and then take the conditional formatting option and
select manage rules... and edit).

It still doesn't work for me.

I have presumed that the value in A1 *In it's entirety* matches A10, e.g
there is a single N in both cells for example.

Yes they are both the same.

 

[Nick Hodge]

Freddie

I am not sure then.

Conditional formatting works on setting a format when the condition is true.
If you type in a spare cell

=A1=A10

Does it return TRUE?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[Freddie]

Freddie

I am not sure then.

Conditional formatting works on setting a format when the condition is
true. If you type in a spare cell

=A1=A10

Does it return TRUE?

Yes, it does.

 

[Nick Hodge]

Freddie

You can forward the file to me if you wish. Take out the obvious stuff from
the email to replay

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[Jordon]

Freddie

You need to look at conditional formatting, in the styles group on the
home tab

Click in A10 and then invoke the menu command, select 'new rule' and
then 'Format only cells that contain'. Select 'Cell value' 'Equal to'
and click on A1 (this will give you =$A$1). Select a format for the text

I've never had much luck using Cell Value. I'd enter Formula Is...

=if(a1=a10,true,false)