Thread: Using a cell's "color" to place a value in a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Using a cell's "color" to place a value in a cell
see:
http://www.cpearson.com/excel/colors.htm
--
Gary''s Student - gsnu200761


"DB" wrote:

I have a groupd of cells. I would like the value of a cell reflected in
another cell based on a cell's highlighted color.

Col1 Col2 Col3
45 Yellow if Col2 is green then Col1
65 Green if Col2 is green then Col1

Is there a way for a formula in Col3 to test Col2 and if it meets the test
of color green, display the value of Col1 in Col3?

Thanks for any help.
Reply With QuoteReply With Quote