Select all of Column A

Click Format Conditional Formatting

Create three conditions:

Condition 1 = If Cell Value is eqaul to High -- then choose your
formatting options.

Click "Add" and repeat for other desired conditions.

Profit.


--
SlipperyPete
------------------------------------------------------------------------
SlipperyPete's Profile: http://www.excelforum.com/member.php...o&userid=31220
View this thread: http://www.excelforum.com/showthread...hreadid=521089