Format with specific RGB Color

[Guest]

My spreadsheet will calculate RGB color values from 0 to 255 for each of R, G, and B. I want a specific cell on the spreadsheet to take the calculated values and shade the cell that color. Continuously variable color 256^3 permutations

Possible?

 

[Chip Pearson]

Larry,

The short answer is that this is not possible. Excel can only
display 56 colors, so any color not in the pallet is converted to
the closest match. Moreover, Excel is limited to 64K rows, and
this is far fewer than 256^3.



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

My spreadsheet will calculate RGB color values from 0 to 255

for each of R, G, and B. I want a specific cell on the
spreadsheet to take the calculated values and shade the cell that
color. Continuously variable color 256^3 permutations.

 

[jeff]

Hi,

You can calculate all the combinations, but Excel is
only going to show those few in its palette. I forget
the number - its only 30 or 40 tops, though.

jeff

-----Original Message-----
My spreadsheet will calculate RGB color values from 0 to

255 for each of R, G, and B. I want a specific cell on
the spreadsheet to take the calculated values and shade
the cell that color. Continuously variable color 256^3
permutations.

 

[Mark E. Philpot]

Hi,
Use the characters.text, see sample below

a,b,c are cells

set a=range("A1")
etc

Selection.Characters.Text = "RGB(" & a & "," & b & "." & c
& ")"


download colorsRGB.xls from
http://au.geocities.com/excelmarksway

regards
Mark E. Philpot
Melbourne Australia

-----Original Message-----
My spreadsheet will calculate RGB color values from 0 to

255 for each of R, G, and B. I want a specific cell on the
spreadsheet to take the calculated values and shade the
cell that color. Continuously variable color 256^3
permutations.