Forum Discussion
Conditional Formatting Bold based on words
Hi, I want to use Conditional Formatting to show the words in bold if any of the following words are in the cell (see list below). Right now, I've created a rule per word. Which means I'm going t...
Hello onlysublime ,
Please use following steps and let me know!
Step 1: Write the list of words in one column
Step 2: Select the column to format
Step 3: Go to Conditional Formatting -New Rule
Step 4: Select "Use a formula..."
Step 5: Write next formula
The Range inside the COUNTIF is your list and the second parameter is the first value of your column to format.
If you need to add more words to the list you only need to modify your range in the formula.
Note: You can assign a name to the range and use it inside the COUNTIF pressing F3, this step is useful if you want to put your list on another sheet inside your workbook.
Regards!
karchavez TY! I will try it! 🙂