Cell Value based on Colour of Cell

[binaryfingers]

Is there a way of being able to look up a value in a cell by the background colour of the cell?

We use a spreadsheet that has several different product codes in column c, and each product code has mulitple values with diferent colour backgrounds on the same line(each colour representing a different division) and I would like to use the background colour of the cell to locate the correct value..

Can this be done?

Thanks,

 

[firefytr]

Hi there,

You would need a UDF for that (which should be asked in the VBA forum707).

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[KenWright]

If the position of the value in the row (ie are all divisons in the same column?) can be used to determine the division then this would probably be a better route to take than the VBA one.

Regards
Ken..........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[SkipVought]

Ken,

Could you elaborate on "...then this would probably be a better route to take..." _{emphasis added by poster}

Skip,

_[red][/red]

 

[mintjulep]

How are the colors applied?

 

[binaryfingers]

hi Mintjulep

They are applied by formatting the background colour by another member in a remote office.

Thanks,

 

[mintjulep]

I'm having trouble understanding

several different product codes in column c, and each product code has mulitple values with diferent colour backgrounds on the same line

 

[binaryfingers]

Hi

Is there a way of being able to cut a section of my spreadsheet for all to be able to fully understand?

Thanks,

 

[firefytr]

Check out Box.net to host files.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[KenWright]

LOL - What I meant was that if there was a logic behind the colouring that could be built into a formula then that would be a better option to take rather than use VBA

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------