Thread: Color Variation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel[_928_] joel[_928_] is offline
external usenet poster
 
Posts: 1
Default Color Variation


I usually record a macro and then maually select the colors I want.
Then use the color numbers from the recorded macro in my code. the
color numbers is a hexidecimal number which is in three parts (Red=0 to
255, Green=0 to 255, Blue=0 to 255).


So you could uses

Red = 25
Green = 50
Blue = 10


Mycolor = (Red*256*256) + (Green*256) + Blue


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=198482

http://www.thecodecage.com/forumz