Display Values within a Background Filled Cell into a Different Cell

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

Hello CC,

It does, but is there a way to simplify this process by using a function? For example whether there is an IF function that I could use? The reason why I'm asking is because it's not always going to be column A that has a background fill, so I will not be able to pick up the desired value.

Cheers,
scchong

Hello Richard,

Uploaded sample workbook of desired result.
Thank you for your time!

Cheers,
scchong

Hello CC,

You are correct in your understanding of my issue.
If VBA is required, I will need help with the coding. If anyone can assist, that would be much appreciated! =)

Cheers,
scchong

Hello CC,

That works great! Is it possible to work this when theres more than 2 columns of data?
I tried to use a range in the IF function, for example =IF(filled(E6:O6),filled(E6:O6),"N/A") it keeps returning N/A.

I must be doing something wrong with the syntax.

Hope you can help again! =)

Kind regards,
scchong

Hello CC,

I figured it out, I had to use nested IF function. E.g. =IF(filled(E6),E6,IF(filled(F6),F6,IF(filled(G6),G6,IF(filled(H6),H6,IF(filled(I6),I6,IF(filled(J6),J6,IF(filled(K6),K6,IF(filled(L6),L6,IF(filled(M6),M6,IF(filled(N6),N6,O6))))))))))

That works great!

Thank you very much for your help.

Kind regards,
scchong