Get Hex Color code without VBA

[NikkiMc204]

Hi hoping you can help me with this query.

I've a range of cells =C35:M35 that have been coloured with various shades of red, amber, green, blue.

In the row below i'd like to show the hex colour code - is there a function/formula to show this or can it only be done via vba?

 

[Dan_W]

This was extremely easy to find both in Google and the Forum search function:

Post in thread 'Is there really no built-in worksheet function to convert RGB values to their hexadecimal equivalent?' Is there really no built-in worksheet function to convert RGB values to their hexadecimal equivalent?

Does that help?

 

[Fluff]

is there a function/formula to show this or can it only be done via vba?

Only with VBA, no xl function can "see" the colour (or any other type of format) of a cell.

 

[NikkiMc204]

Gah, ok thanks all for the feedback.

 

[Fluff]

Glad we could help & thanks for the feedback.