How do you highlight a cell based on the value in the total. I saw one post that asked this question but the answer showed how to do it based on a specific value.
I can do product cost > 1000, in the conditional variable. But when I do product cost > total (product cost), i get a data type error.