Awesome, I just really needed to take a look at it, thanks. I first tried changing the 'applies to' formula to =$A$2, but it changed all of the rules to match A2's. So I went back in to the rules and changed them back to A1's and left the 'applies to' formula as =$A$2 and it kept it. Now A2 highlights based on A1's value. Thanks for the very helpful nudge!! Again, you are a live saver!