Forum Discussion

FREDERIC_LAFARGUE's avatar
FREDERIC_LAFARGUE
Copper Contributor
May 31, 2023

Colourise cell without VBA

Hello (DeepL Traduction)


I want to colourise a certain number of cells according to an RGB value defined in a cell.

Example "5B8BAA" which is a style of blue.

Is this possible without Visual Basic?

 

Best regard

Fred

developer
excel

2 Replies

  • mtarler's avatar
    mtarler
    Silver Contributor
    May 31, 2023

    FREDERIC_LAFARGUE dynamically, no.  but manually yes.  click on the cell(s) and in the drop down for the color select More Options and then in the Colors pop-up window select Custom Tab and then enter that value in the Hex (or convert to equivalent RGB values):

    EDIT - by dynamically 'no' I mean you can't set the color dynamically based on inputs on the sheet but you can still use Conditional Formatting to dynamically select/determine which cells that ('fixed') color gets applied to.  So I guess the simple answer to your question was no, sry.

    Oh, btw, I believe you could also do it using Scripts (as opposed to VBA) which will work in the browser excel but require a button/action. 

Resources