Conditional Formatting: Highlight A1:G1 if A1 containing "PL"

As per title, I have some question about Conditional Formatting.

I might to highlight A1:G1 if A1 is containing PL.

Example:
A1 = PL12345
A1:G1 is highlighted with yellow color.

Thank you.

Try this in conditional formatting

Please Login or Register  to view this content.

Thank you very much. It's Solved.

using this method is it possible to highlight a range of cells if the main cell is 100%?

For example i have a master spreadsheet with values pulled from other workbooks (linked) and i want to highlight certain cells if the main cell is 100%

Hello 13lack13lade,

Please don't post question on solved or other member thread. Start your own. If you feel any thread is something relevant to your problem, please post the URL of thread.

http://www.excelforum.com/forum-rule...rum-rules.html