[SOLVED] Vba to fill row below based on cell value above

[adamheon]

I'm looking for a code that automatically will gray out a defined row below a cell that contains specific text. Example:

if column D contains "2P" the row below that cell from B to E is filled gray.

D6 = 20A-2P
cells B7:E7 are filled gray.

I attached a sample spreadsheet too.

[jindon]

Conditional Formatting?

1) Select B6:E and rows that you want to appy
2) Formula: =ISNUMBER(FIND("-2P",$D5))

[adamheon]

yes awesome! i didn't even think of conditional formatting for some reason.. couldn't think of the formula that i would use. Thanks for the quick response!