How Can i use the cell colors as logical tests?
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.
|