I am familiar with how to apply conditional formatting to an entire row based on the value of a single cell within that row for simpler scenarios--for example, the cell contains a specific number or string. However, the same methodology does not appear to work for the percentile rank function. I...