conditional format based on text?

Jonathan Brotto 1,076 Reputation points
2022-03-28T16:10:15.207+00:00

Is there a conditional format where if a certain text is written I can highlight values in another column?

187631-image.png

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,674 questions
{count} votes

Accepted answer
  1. Ceasar Chen_MSFT 4,391 Reputation points
    2022-03-29T08:30:57.183+00:00

    Hi, @Jonathan Brotto
    You can click New Rule in Conditional Formatting, select Use a formula to determine the cells to be formatted, and write the formula in the dialog box. The example steps are as follows:

    1. Select the area where you want to highlight the cells.
    2. Click the Conditional Formatting button in the Home tab, and select New Rule in the pop-up menu.
    3. Bring up the New Formatting Rule window, and the "Select Rule Type" is Use a formula to determine which cells to set.
    4. Enter =$B1=”NO” in the “Format values that match some formulas” box, and then click the Format button to select the desired cell format to complete the conditional formatting.
      187799-image.png
      In the formula you can enter the text you want.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

0 additional answers

Sort by: Most helpful