| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change tab color based on current color of a cell | Excel Discussion (Misc queries) | |||
| Can you change the color of one cell based on the color of another | Excel Discussion (Misc queries) | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| change fill color of a range of cells based on color of a cell? | Excel Programming | |||
| Browse Forms Controls and change TextBox color based on cell color | Excel Programming | |||
![Aria[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
