Forum Discussion
FREDERIC_LAFARGUE
May 31, 2023Copper Contributor
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 Bas...
mtarler
May 31, 2023Silver Contributor
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.
FREDERIC_LAFARGUE
May 31, 2023Copper Contributor