Ifs statement based on text color

erinmagee

New Member
Joined
May 24, 2018
Messages
2
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!
1615950376070.png
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

mart37

Well-known Member
Joined
Aug 4, 2017
Messages
1,096
Office Version
  1. 2016
Platform
  1. Windows
You can filter each column on textcolor.
Select all the cels.
Type the text and use CTRL+ENTER instead of ENTER.
 

mart37

Well-known Member
Joined
Aug 4, 2017
Messages
1,096
Office Version
  1. 2016
Platform
  1. Windows
Maybee you can use FIND AND REPLACE. Looking to format text = black Replace with BASE.
 

Forum statistics

Threads
1,148,145
Messages
5,745,050
Members
423,917
Latest member
Frank1931

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top