View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aria[_2_] Aria[_2_] is offline
external usenet poster
 
Posts: 34
Default Change formulas into values based on cell color

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 ***