Hello,

I'm in need of help to copy and display values within a Background Filled Cell into a blank Cell. For example, in a worksheet, I have A1:B10 with data. However within this array there are some cells with it's background filled with different colours (no conditional formatting).

E.g. the following cells are randomly filled with any colour:
B1
A2
A3
B4
A5 and so on.

Irregardless of what color is being used to fill these cells, is there a way to copy the value of the background filled cell in A1:B10 into C1:C10? Note: If Column A is background filled, Column B will not; and vice versa.

Hope you can help.

Kind regards,
scchong