Need a formula for returning the value of the cell shading in a cell

J

Jesse O

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!
 
R

russell-skimmer333

Try,

Sub colourtest()
s = ActiveCell.Interior.ColorIndex
MsgBox s
End Sub

HTH's
Russell.
 

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

macro on different reports CTRL+F in formula 2
Would like to input 3 letters into a cell, each having a different numerical value 5
conditional format - table - cell empty return default color 1
Need to Capture the initial value of a cell. 1
count cells with diagonal cell borders 0
count cells with diagonal borders 3
change colors in a range of excel cells based on another range of cells 1
Find matching cell and return value of a different cell 5

Top