Excel 2007 : Highlighting Multiple Cell Values in Same Row If .....

[boba7523]

Hi guys, I'm trying to create a spreadsheet where I want to highlight an entire row of selected cells if a certain cell within the highlighted cells contain the text "S."

Ex:
A1 | B2 | C3 | D4 | E5 | F5

Highlight A1:F5 IF cell B2 contains the letter "S".

I tried using conditional formatting but it seems like that only highlights one cell... Does anyone have any clue if Excel can do that?

Thanks!!