Ifs statement based on text color

[erinmagee]

Hello - hoping to find some help to change the pricing in each cell to text ('Base', 'Ad', or 'TPR') based on font color. If font color is black, then change price to text "Base" if font is red, then change price to text "Ad" if font is blue, then change price to text "TPR". I've looked for IFS statement using this criteria, but cannot find anything that works - not sure if there is something or if need to write a macro or VBA - can't figure those out either ... would love any help! Thanks!

 

[mart37]

You can filter each column on textcolor.
Select all the cels.
Type the text and use CTRL+ENTER instead of ENTER.

 

[mart37]

Maybee you can use FIND AND REPLACE. Looking to format text = black Replace with BASE.