IF/THEN formula for conditionally formatting part of a row?

[HLS811]

Hi All.. OK - I'm stumped (its not tough to do..)

I want to add a formula which will make a portion of a row highlighted in a specific color based on the information from one of the cells.. for example -
If in cell A1 the word HIGH is entered, I'd want Cells B1-B4 to be highlighted in Green...
If the same cell has MID entered I'd want that range to be yellow, and if LOW is entered, I'd want it to be in red...

Is that possible...?

Thanks in advance

 

[HLS811]

Re: IF/THEN formula for conditionally formatting part of a r

AWESOME!!! You are a genious!

Thanks for your help!!