Conditional Formatting based upon meeting 2 criteria

[kimi4989]

My mind has gone blank and I can't remember how I did something. I need to highlight entire rows in a sheet when column B contains "Smith" and column I contains "02". Can someone help? Thanks in advance.

Kimi

[sweep]

Hi,

Use a formula along the lines of

=AND($B1="Smith",$I1="02")

note the position of the dollar sign to indicate formatting of the whole row.

[ben_hensel]

Format According to Formula when true:

=AND($B1 = "Smith", $I1 = 2)

apply it to the whole area you want formatted.

[Vikas_Gautam]

I cant select the whole row..
But i managed to shade the two cells..