How can I retrieve the format of a cell?

  • Thread starter Thread starter Chris
  • Start date Start date
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
 
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
 
Back
Top