Need help with getting text and cell info from another cell together.

[fruggle21]

I have a long list of bin numbers that need to find their way into a cell that states
*** Selection.FormatConditions.Add Type:=xlTextString, String:="374327", _
where it says 374327, I need that to come from a long list of cells that have similar six digit numbers.

basically I want it to do something like *** Selection.FormatConditions.Add Type:=xlTextString, String:="A2", _ etc.
Selection.FormatConditions.Add Type:=xlTextString, String:="A3", _

If anyone could help me out that would be great!
as a side note this comes from a macro recorded with conditional formatting.

[fruggle21]

also the quotation marks around the number and the comma and underscore after are part of the text and need to be there

[vlady]

Welcome to the forum.
May I suggest that you upload a sample file of atleast 10 data set including expected out put so others can help.

Thank you for joining.

[fruggle21]

Please help anybody, I have been going at it for a couple of hours to no avail.

[FDibbins]

Hi and welcome to the forum

You cannot change just column A to include the values in column E, you will need to use a helper column for this (unless you want to use VBA), So maybe something like this, copied down (I used column B)?
=A2&""""&E2&""""

If you dont want the helper, you can then copy/paste values from B to A, and then delete B

[fruggle21]

Thanks, but actually I do want to use VBA if that helps. Basically I have a huge sheet of information. One column has 16 digit codes, and I need the codes that begin with certain 6 numbers (i have 1500 of these 6 digit codes) to mark themselves red or something through a macro. On the attached file, column A is actually a recorded macro using conditional formatting. It shows a rule that marks red any cell that begins with those six digits.

If there is an easier way to build a macro using conditional formatting or something else like a function then that would be awesome.

[FDibbins]

OK, then I will move this to the VBA forum to get better coverage there

[fruggle21]

OK, then I will move this to the VBA forum to get better coverage there

Ok thanks I appreciate it