Numerical value of a colour

[cata2200]

Hello all

I'm looking for a function/formula to get the numerical value of the background colour of a cell.

Thanks
Catalin

 

[pedie]

Not sure bout numbers but i use vbwhite, vbyellow etc i that is more easy
to remember

 

[pedie]

Just googled and found something....try this link

 

[cata2200]

Not sure bout numbers but i use vbwhite, vbyellow etc i that is more easy
to remember

Thanks, but how to get the value?
For example: $A$10 is yellow with pattern black, vertical. What is the numerical value of this colour?

Regards,
Catalin

 

[SteveO59L]

Try Using the macro recorder.


Start the recorder, then colour the cell.

Stop the recorder and look at the code produced.

This should give you all of the properties.