Hello,

I have a big table which maps our members' presence to dates by using
special cell background color. So for example one color means "is ill
and another means "is present" and so on...
Unfortunately I have to transfer this table to a sql database and
could not find a way to export cell-background colors to a .csv file.

So my question is:

Is there a simple way to change the celltext according to the cell'
background-color in the whole worksheet ?

For example:
cell-background = "none user set color" - cell-text = ""
cell-background = "green" - cell-text = "green"
cell-background = "red" - cell-text = "red"

and so on ...


Thank you for your answers

K. Tückin

--
Kai Tückin
-----------------------------------------------------------------------
Kai Tücking's Profile: http://www.excelforum.com/member.php...fo&userid=1525
View this thread: http://www.excelforum.com/showthread.php?threadid=26882