View Single Post
 
Old 03-07-2024, 07:51 AM
MC147 MC147 is offline Windows 10 Office 2021
Advanced Beginner
 
Join Date: Feb 2022
Posts: 34
MC147 is on a distinguished road
Default

Thanks NoSparks, but I am not sure that is correct.
C8 in HEX is 200 and FF in Hex is 255,
So it is the C8FFFF (i.e. the last 6 digits before the final &) that represents the colour of RGB (255, 255, 200) - the order is reversed for the 3 colours.
Its the first digits &H00 that are puzzling and why the same colour in Excel has a code of &H80000018&

Your link was useful though as it says that Excel only recognizes names for Color 1 through 8 (Black, White, Red, Green, Blue, Yellow, Magenta, and Cyan).

This probably explains it as Excel is clearly using a completely different system for storing the colour codes as is used by Access.
Reply With Quote