CF colored cells are difficult to work with because Excel does not recognize the
colorindex of a CF colored cell.

You would be better off comparing the value(s) that the CF uses.

For more information on CF Colors and some code see Chip Pearson's site.

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


Gord Dibben MS Excel MVP


On Tue, 15 Jan 2008 05:09:00 -0800, kashof
wrote:

i applied conditional formating to one cell. it changes the color when the
condition is right. can i compare this color with another cell color and put
some formula that says "IF THE COLOR IN THE CELL S1 MATCHES THE COLOR OF CELL
T1,RETURN THE VALUE THAT IS IN CELL A1"???
I guess u guys understand what i need......do u?? u must have....u people
are better in excel. pl reply.thank u.