Change Rows Color Depending on Cell Value in that row.

[mrgillus]

Normally I would not have a problem with something like this just using Conditional Formatting, however, I need to color code based on more than 3 different values.. The attached Sheet demonstrates better.. I setup the first 3 using conditional formatting, but don't know how I can write the code to handle all of the colors...

Thanks for the help!

FYI.. I searched the forums and couldn't locate any examples that matched my particular question..

[Palmetto]

You will have to use VBA since your version of Excel is limited to a maximum of the three Conditional Formats.
See link below.
Get Around Excels 3 Criteria Limit in Conditional Formatting