How can I retrieve the format of a cell?

[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

 

[Debra Dalgleish]

You can use programming to determine the colour. Chip Pearson has
instructions on his web site:

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

 

[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

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