 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008Formula needed please...
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  SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk > 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. Hi Nick, Many thanks for the quick response, but this doesn't seem to work for me, maybe I'm doing it wrong? > Freddie > [quoted text clipped - 11 lines] >> I'm using Excel 2007 >> Many thanks for any replies. 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. SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS 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? [quoted text clipped - 14 lines] >>> I'm using Excel 2007 >>> Many thanks for any replies. > 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. >> Hi Nick, Many thanks for the quick response, but this doesn't seem to >> work for me, maybe I'm doing it wrong? [quoted text clipped - 14 lines] >>>> I'm using Excel 2007 >>>> Many thanks for any replies. 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? SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk >> Freddie >> [quoted text clipped - 31 lines] >>>>> I'm using Excel 2007 >>>>> Many thanks for any replies. > Freddie > [quoted text clipped - 6 lines] > > Does it return TRUE? Yes, it does. >>> Freddie >>> [quoted text clipped - 31 lines] >>>>>> I'm using Excel 2007 >>>>>> Many thanks for any replies. Freddie You can forward the file to me if you wish. Take out the obvious stuff from the email to replay SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk >> Freddie >> [quoted text clipped - 44 lines] >>>>>>> I'm using Excel 2007 >>>>>>> Many thanks for any replies. > Freddie > [quoted text clipped - 4 lines] > 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) SignatureJordon |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.