Conditional Formatting

  • Thread starter Thread starter phillyfan
  • Start date Start date
P

phillyfan

I have a spreadsheet made but I want the text in the cells to chang
formatting (italics) if that cell (text) is equal to any of a list o
text cells that will be listed below the table. I know how to chang
formatting if equal to (or not equal to) a single item but not one of
list.

Any help is greatly appreciated,

phillyfa
 
Select the cells that you want to format (e.g. A2:D20)
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type a formula that refers to the active cell:
=COUNTIF($B$22:$B$30,A2)
where B22:B30 is the list of text cells below the table
Click the Format button, and choose your formatting options
Click OK, click OK
 
Back
Top