In VBA help, type 'PatternColorIndex Property' in the search box then click
on it when the menu comes up. It displays the palette with the corresponding
numbers.

"Dickie Worton" wrote:

Hi,

I am trying to construct quite a complete worksheet that will utilise the
VBA code I have found elsewhere in the discussion groups and which will allow
me to have more than three instances of conditional formatting per cell (five
is my aim!)

I know which five colours I need but don't know how to identify the VBA code
for these colours that I will need to use. Can anyone tell me how I can
identify the code for these colours, please? I though that the worksheet
function CELL("color") might do this but it doesn't work as it just returns a
zero value if the cell is shaded.

This will at least give me a starting point for what I would wish to move on
to (look out for further postings when I get to that!)

Many thanks in anticipation,

Dickie