How to know if a cell have colour? exist a formula?

**jamiguel77** · 01-30-2013, 02:51 AM

hi friends i add a image, how to put something on B2: =ifcolour(A2,yellow,1,0) if color = yellow put on B2 a 1 otherwhise a 0.?

is easy? or need some VB Code?

i explore the forumla: =CELL but not help me.

thanks

**:) Sixthsense :)** · 01-30-2013, 03:00 AM

Confirm us how the colors are added to those cells? Is it done manually or using conditional formatting?

**FDibbins** · 01-30-2013, 03:01 AM

you will need VBA for this (and my VBA sucks). There is no formula that I know of that will determine if a cell has color and what that color is

**jamiguel77** · 01-30-2013, 03:10 AM

Manually Formated.... i am see this VBA Code but count, not return me a value of 1:

http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

Any advice?

thanks