Conditional Format part of row based an a Cell

[Xirrus1983]

I need to highlight the rows from A27:P:2000 based upon the value of Column B. The column can be: "SU-ARRAYOS-PREM-1" or "SU-HARDWARE-PREM-1" or "SU-APPLICATIONS-PREM-1" and needs to highlight a different color for each one.

Thank you in advance for anyone who can assist.

 

[sulakvea]

by column can be "", "", "" - you mean the corresponding value in the same row in Col B, right?

and if so, the entire row A:P needs to be highlighted. it is gonna jack up the size of the file, u know that right? wanna use VBA instead?

 

[Smitty]

Select A27:P200 and in Conditional Formatting you can use Formula Is-->=$B1="SU-ARRAYOS-PREM-1"

Repeat for the other two conditions.

HTH,