Using RGB Value to change background color of a cell

[Andrew Daly]

I have a what I though was a fairly simple task but after an hour of searching it appears not. I am not a coder and have limited Excel knowledge which adds to my pain.

I have a sheet with two columns, column A contains RBG values 255,255,255 in this format. I want column B's background color to be formatted to that color. so in this case white (not a great example color but you get the idea).
This needs to work all the way down the sheet, regardless of the number of rows.

Hope you can help an idiot?

thanks
Andrew

 

[Michael M]

Right click column Header"B"
RClick formatcells>>Fill>>morecolors>>custom>>populate the RGB boxes as required