Search for value. replace with formatting

R

rbmcc

Is it possible search for the value of cell A1 in all columns from C
onward and replace it with the value and formatting of B1, then so on
and so forth with A2/B2, A3/B3...etc.
So, basicly I have a list of values in column A and a list of
replacement values and formatting in column B and I want to apply that
to the rest of the spreadsheet.
 
R

rbmcc

bumpidy? I've yet to figure this one out, and assume by the reply it is
possible, just varries based on version
 
R

rbmcc

Bump? I hope that a bump every couple days isn't annoying. I'm sure
this is possible. But I'm terrible with macros. Never had much luck
programming in any sense :(
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel conditional formatting with Weeknum 4
Find/replace 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Conditional formatting using relative refrencing 1
Altered pasting functionality 3
VBA to create new data help please 2
Conditional Formatting with VBA 4
Macro for Creating Word Document!! 5

Top