Forum Discussion

Beth ten Have's avatar
Beth ten Have
Copper Contributor
May 12, 2020
Solved

Add Cell Fill Colour Based on Hex or RGB

Is it possible to fill a cell with a colour based on either the hex code or the RGB values of that colour (they would be in neighbouring cells in the same row) without using VBA?
Excel on mobile
Formulas and Functions
office 365
  • CVWISMO's avatar
    CVWISMO
    Aug 02, 2023

    Beth ten Have I just figured out a solution here for those still scratching their heads.

     

    Make a table with:

    • Column A: Insert your hex codes and name the column "HEX"
    • Column B: Name this column "LINK" and use formula:
      • {="https://www.colorhexa.com/
        • Make sure to remove the braces before and after the above formula
    • Column C: Use formula {=image(@[LINK])}

    voila

     

CVWISMO's avatar
CVWISMO
Copper Contributor
Aug 02, 2023

Beth ten Have I just figured out a solution here for those still scratching their heads.

 

Make a table with:

  • Column A: Insert your hex codes and name the column "HEX"
  • Column B: Name this column "LINK" and use formula:
    • {="https://www.colorhexa.com/
      • Make sure to remove the braces before and after the above formula
  • Column C: Use formula {=image(@[LINK])}

voila

 

SacredSteve's avatar
SacredSteve
Copper Contributor
Sep 08, 2024

Could you please give an example showing how to do the same exact thing only with the coloring of TEXT within a cell instead of coloring the background of a cell?  CVWISMO 

  • SacredSteve's avatar
    SacredSteve
    Copper Contributor
    Sep 08, 2024
    Unfortunately, I could not get the original solution to work.
    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Sep 08, 2024

      SacredSteve 

       

      • In the post marked as best response confirmed there's a little mistake. The 3rd bullet should say:
      =IMAGE([@LINK])

      NOT:

      =IMAGE(@[LINK])
      • The https://support.microsoft.com/en-us/office/image-function-7e112975-5e52-4f2a-b9da-1d913d51f5d5 function is currently only available with Excel 365 & Excel Web/Online

      If you run such a version try the attached where this works after fixing the above little typo:

       

      • SacredSteve's avatar
        SacredSteve
        Copper Contributor
        Oct 04, 2024

        unfortunately, i am using excel 2010.  I found a workaround by creating a macro that does not have to access an external site.  I've decided to market what I created for anyone willing to value what i've come up with as a useful tool for their creative work.  Here is my youtube demo: https://youtu.be/F0sbXOyxum8?si=GKbbw_axGq02GLt2

Resources