May 11 2020 07:26 PM
May 12 2020 12:10 AM
May 12 2020 07:18 PM
May 13 2020 12:34 AM
HEX code is different for each row, for each cell of each row, or the same for all rows or what?
Dec 29 2020 07:30 AM
Hi@Beth ten Have , I had a similar task and was wondering if you found a way to fill adjacent cell with the colour matching the hex code entered in the same row?
Dec 30 2020 01:23 AM
Without VBA it's not doable.
The nearest solution would be the feature "conditional formatting".
JC
Aug 02 2023 08:30 AM
@Beth ten Have I just figured out a solution here for those still scratching their heads.
Make a table with:
voila
Sep 13 2023 07:30 PM
This is amazing!!!! @CVWISMO
Thank you so much!