PC Review


Reply
Thread Tools Rate Thread

Change formulas into values based on cell color

 
 
Aria
Guest
Posts: n/a
 
      23rd Oct 2006
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

*** Sent via Developersdex http://www.developersdex.com ***
 
Reply With Quote
 
 
 
 
acampbell012@yahoo.com
Guest
Posts: n/a
 
      23rd Oct 2006
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


Aria wrote:
> 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
>
> *** Sent via Developersdex http://www.developersdex.com ***


 
Reply With Quote
 
Aria
Guest
Posts: n/a
 
      23rd Oct 2006
It worked. Thank-you very much. This really helps me a lot.

Aria


*** Sent via Developersdex http://www.developersdex.com ***
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change Cell color using formulas =?Utf-8?B?QWxleENlZ2E=?= Microsoft Excel Misc 1 10th Oct 2006 09:49 PM
Format cell color based on multiple cell values Zenaida Microsoft Excel Misc 1 10th May 2006 07:31 PM
Format cell color based on multiple cell values Zenaida Microsoft Excel Misc 3 9th May 2006 11:56 PM
change fill color of a range of cells based on color of a cell? =?Utf-8?B?RGFyTWVsTmVs?= Microsoft Excel Programming 0 2nd Mar 2006 06:35 PM
Browse Forms Controls and change TextBox color based on cell color =?Utf-8?B?U3RlZmFuVw==?= Microsoft Excel Programming 0 21st Nov 2004 04:28 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:37 PM.