Thread: Need a formula for returning the value of the cell shading in a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
russell-skimmer333 russell-skimmer333 is offline
external usenet poster
  
Posts: 1
Default 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 With QuoteReply With Quote