Formula needed please...

  • Thread starter Thread starter Freddie
  • Start date Start date
F

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.
 
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
 
Hi Nick, Many thanks for the quick response, but this doesn't seem to work
for me, maybe I'm doing it wrong?
 
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
 
Nick Hodge said:
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).
Click to expand...

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.
Click to expand...

Yes they are both the same.
 
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
 
Nick Hodge said:
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?
Click to expand...

Yes, it does.
 
Nick said:
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
Click to expand...

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

=if(a1=a10,true,false)
 
Back
Top