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!