| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a formula for returning the value of the cell shading in a cell
Is there a forumla I can use to return the numerical value of what color
a cell is shaded or its background color is? Say I have a cell B24, and i want to set cell D24 equal to the numerical value (of the background or shading color) of B24. Is this even possible? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need a formula for returning the value of the cell shading in a cell
Try,
Sub colourtest() s = ActiveCell.Interior.ColorIndex MsgBox s End Sub HTH's Russell. -----Original Message----- Is there a forumla I can use to return the numerical value of what color a cell is shaded or its background color is? Say I have a cell B24, and i want to set cell D24 equal to the numerical value (of the background or shading color) of B24. Is this even possible? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Shading via a formula? | Excel Discussion (Misc queries) | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| Returning the formula in another cell | Excel Worksheet Functions | |||
| Is there a formula, function or macro that accounts for shading of a cell or row? | Excel Discussion (Misc queries) | |||
| Returning the formula in a cell | Excel Discussion (Misc queries) | |||
Linear Mode
