formula & text

I have a list of first and last names in column A, some first names repeat. I want to type in a first name in some cell (say H1) and all the cells in the list that have that same first name will be highlighted yellow.

Hi all I am trying to use a formula to look for text but I'm stumped! I can get "IF" working fine to check one cell or to check that something is entered in all of the cells but I want it to check in ANY of these cells. I also want it to return differant results from differant sheets Heres a...

Hi all I am working on a big spreadsheet and got a bit stuck. I would appreciate some help from you. I'd like to attach a spreadsheet - how do I do that? Basically, I have a list of clients that receive different reports. Column A shows the recipient name, column B shows the report ID. So...

Hello, Im using Excel 03. I would like to know if their is a way to turn a cell red if the same data is put in a different cell in the same column. Example A1 = 1 A2 = 2 A3 = 3 < Cell would turn red A4 = 3 < Cell would turn red A5 =6 A6 = 2 < this and A2 would turn red <CELL cell...

Hello all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I want to write a formula that part of it is written, as a text, in another cell.<o:p></o:p> I common circumstances I should use the “indirect” but I am referring to a closed workbook … so no way to...