How to know if a cell have bg color?

[Rixn]

I'm tryiung to find info on how to find out if a cell have a color or not? I hope it can be done with normal formulas, but if I need the VBA support I hope you can explain a bit more since I'm not so good at that (where to put the script, and so on).

Deeper decription:
I have a range of cells, D5:M10.
Most cells have numbers.
Some of those have been marked with a background color (yellow).
I want to be able to find out which cells have been marked with the color?

Hope someone can help me!
I did find something here when I searched, but that was not exactly what I needed and the solution was in VBA and too high level for me.
/Lars

 

[GlennUK]

How have those cells been coloured? By normal formatting, or conditional formatting?

 

[Rixn]

Normal formatting.

 

[GlennUK]

OK, that could be done by using an defined name to get the information. What do you want to do with the information when you have it? Are you going to have cells elsewhere to contain flags representing this? Or some other purpose?

 

[Rixn]

As long as I can get the Yes or No for if each cell is colored, I'm happy.
Then I will compare that with another set of cells to see if the hits match.

 

[GlennUK]

OK, let assume you are going to have the Yes or No in cells N5 to W10 ( i.e. 10 cells to the right of the area you are testing ), select cell N5, then define a name ( Insert/Name/Define or Formulas/Define Name ) of HasColCellTenToLeft, with a definition of :

=GET.CELL(63,INDIRECT("RC[-10]",FALSE))

Then type as a formula in cell N5 this:

=HasColCellTenToLeft>0

and copy to the other cells in the area N5:W10.

You will now have a block of TRUEs and FALSEs where the TRUEs represent the cells in block D5:M10 that have cell color fill.