MrExcel Publishing
Your One Stop for Excel Tips & Solutions

HTML


Posted by Bruce Davis-Goff on February 12, 2002 3:25 PM

Does anyone know how I can make a cell turn the hex colour specified in another cell? Thanks


Posted by Mark W. on February 12, 2002 3:32 PM

Don't know, but...

...have you fooled around with the Microsoft
Script Editor (Shift+Alt+F11)?

Posted by Juan Pablo G. on February 12, 2002 5:44 PM

Well, don't know if this works well enough.

In B1 i have

&H00FFC0C0

Which is a "light" blue.

I put this code somewhere..

Sub A1Color()
[A1].Interior.Color = CLng([B1])
End Sub

And it puts the light blue as the background of A1.

Juan Pablo G.