Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to concatenate based on font color
I have imported a csv file that splits the names into 3 different colomns. I
am trying to merge the names back together but only when it meets certain criteria. Cannot figure out how to make the following formula work only on cells that have a font ColorIndex of 3. Have searched but can't find quite the right answer. Thanks in advance for your help. Sub ConcatColor() lastrow = Cells(Rows.Count, 1).End(xlUp).Row For i = 2 To lastrow '<<assumes header row Range("P" & i) = Cells(i, 7) & " " & Cells(i, 8) & " " & Cells(i, 9) Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
change font color based on a value | Excel Worksheet Functions | |||
How do I concatenate text to keep the text's original color/font/s | Excel Discussion (Misc queries) | |||
Sum based on font color | Excel Programming | |||
Portion of concatenate formula to have different color and font fo | Excel Worksheet Functions |