Change formulas into values based on cell color

  • Thread starter Thread starter Aria
  • Start date Start date
A

Aria

Hello,
"Source" tab includes formulas that link to other tabs. Those specific
formulas are indicated by color code [Light Turquoise].

After copying the entire sheet's data (Select All -> Copy) into another
tab called "Destination".

How do you:
1) Change the contents of all [Light Turquoise] cells only from formulas
into values?
2) Then, change all [Light Turquoise] cells into no color?

Thanks so much,
Aria
 
This will change the cell interior color and formulas to values after
you copy to the new sheet.

Sub TestFormat()
Dim MyCell As Range
For Each MyCell In Selection
If MyCell.Interior.ColorIndex = 8 Then
MyCell.Value = MyCell.Value
MyCell.Interior.ColorIndex = xlColorIndexNone
End If
Next
End Sub
 
You must log in or register to reply here.

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

Copy value from changing cells without VBA 1
Lookup and Enter Value to Other Tab on Change in Cell 0
Cell color 4
changing a color based on another color change 1
Button Color based on cell 12
Coloring a cell based on a formula 1
Insert Formula based in cell user clicks 2
Cell data based on autoshape color 2

Back
Top