Search code examples
excelexcel-formulaworksheet-functionconditional-formattingcountif

Conditional Formatting of two cells based on a value's presence in a column

In column B11:B20 users can select a value from a drop down list - the value I am working with is Other.

If the user selects Other from the list, Cells 11 in columns N and O need to highlight.

I can get the formatting working for if the user selects Other in the first cell (B11) but can't work out how to get it to work for B12:B20?

Solution

  • The way I understand your requirement, please select N11:O11 and HOME > Styles - Conditional Formatting, New Rule..., Use a formula to determine which cells to format, Format values where this formula is true:, enter: 

    =COUNTIF($B11:$B20,"other")>0

    Format..., choose your formatting, OK, OK.