Cell value based on other cell's conditional format font color [Closed]

Report
Posts
1
Registration date
Monday April 6, 2015
Status
Member
Last seen
April 6, 2015
-
Hello,
I have conditional formatting on cell a1 that if it is from a list of text then its font color is blue.
in b1 cell i want to write "Blue" if a1 font color is blue other wise I want to write black in b1 cell is it possible in excel

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!