Thanks for looking at the table. There was a problem with text versus numbers mix in some of the columns. I've addressed that, turned text to #s and got rid of the %. With that, conditional formatting now works. It was problematic in that using shift up as suggested skewed the data - on the larger table there are more instances like the one you mention.