Cell color definition

[Landyman]

Hello, is there anyway to return the "value" of the color format of a cell?
eg if cell is yellow = 1, if blue = 2.
Im assuming Excel must have built in values for colors, which would be fine to return

I have a huge list, and I want to filter on those cells which are non-colored, figured a formula returning cell color, then could filter out the clear cells

Cheers

[VBA Noob]

Hi,

You need some VBA code.

See attached link

http://www.cpearson.com/excel/colors.htm

Post back if you need help using VBA

VBA Noob