paradox
paradox

Reputation: 1276

Excel 2007 Format Row of Cells containing certain text

I am attempting to perform conditional formatting in Excel 2007 by checking if a cell has a specific string in it and therefore highlighting the entire row corresponding to the text. However, Excel 2007's Conditional Formatting only allows me to highlight that specific cell. Is there a workaround to this without having to get my hands dirty with VBA?

Upvotes: 1

Views: 2533

Answers (1)

paradox
paradox

Reputation: 1276

Formula is: =IF($G1="matching_string",true,false) Do this somewhere in row 1, then copy the format everywhere you need it. The $ sign locks the formula on column G, while the row number is floating.

Upvotes: 1

Related Questions