How can I retrieve the format of a cell?

C

Chris

Dear all,

A cell A1 is conditionally formatted so that it is either red (FF0000),
green (00FF00) or blue (0000FF). May I know if I can write a function for
another cell B1 such that it shows a word "RED" if A1 is red, a word "BLUE"
if A1 is blue and a word "GREEN" if A1 is green?

Thanks in advance.

Best Regards,
Chris
 
R

Ron Rosenfeld

Dear all,

A cell A1 is conditionally formatted so that it is either red (FF0000),
green (00FF00) or blue (0000FF). May I know if I can write a function for
another cell B1 such that it shows a word "RED" if A1 is red, a word "BLUE"
if A1 is blue and a word "GREEN" if A1 is green?

Thanks in advance.

Best Regards,
Chris
Click to expand...

If the color change is due to conditional formatting, the function that you
need to write is one that mimics the conditional formatting function.


--ron
 
Top