View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kashof kashof is offline
external usenet poster
 
Posts: 2
Default 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.