Conditioal Formatting Color Problem 1

[TheAceMan1]

Howdy All!

When using conditional formatting in VBA for Excel, it appears that colors outside of the range of the color palette indices don't take. As an example ... [blue]Light Green[/blue] ... a value of [blue]RGB(236,255,236)[/blue] or [blue]15532012[/blue] shows as white! (works just fine in Access).

Is there anyway to fix this or perhaps change the color palette?

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[linney]

Anything in the first link that might help?

Excel's color palette explained

http://answers.officewriter.com/excels-color-palette-explained

http://www.google.com.au/search?q=V...&ie=&oe=&redir_esc=&ei=98hLT-HQJ6qSiAeDkvCgCA

 

[TheAceMan1]

linney . . .

[blue]Roger the links[/blue] ... just what I needed! ... Colors here I come! ...

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]