Excel calculation based on cell font color

[joel009]

This problem was presented to me at work. I do not know if it is even possible. Any input appreciated.

We have data going into the cells with 3 or 4 different colors. Is there a way to use the font color in the cell to base calculations on?

Thanks in advance for looking
Joel

Joel

 

[SkipVought]

Hi,

USER colored cells as DATA is a really BAD policy. Color pallets are not necessarily consistent from one user to another.

Rather, it is better to use Conditional Formatting to color and format, which is based on data values. VALUES is what you need to calculate.

Of course, it is possible to TRY the color approach, but it is pitfall strewn.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

Example

select case activecell.interior.color
  case vbblue
     'do blue calc here
  case vbred
     'do red calc here
  case vbgreen
     'do green calc here
end select

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Deniall]

I'm 101% with Skip on this. Data should drive colour rather than colour driving data.