Excel - setting color of cell from RGB code

[dqrose]

In Excel, is there a way to set the background color of a cell from its RGB color code? For example, if cell A1 contains the hex value FF0000 (pure red) then I want the background color of that cell to be pure red.

Cheers

 

[AnotherHiggins]

Sorry, this cannot be accomplished without a macro (VBA). If you would like to pursue a VBA answer, please repost in forum707, the VBA Visual Basic for Applications (Microsoft) Forum.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[dqrose]

Okay - many thanks.

 

[xlhelp]

Excel can only display 56 colors at a time that are in the palette (tools; options; color). If you use VBA for an RGB or a HEX value Excel will pick the closest color within the existing palette.

The palette can be modified for any particular workbook - under tools; options; color.




Member- AAAA Association Against Acronym Abusers