I have a spreadshet that shows my cost for a particular product in one cell,
my competitors price in another and then in the following columns I have a
cost plus formula (cost +10%, cost+20%, and so on) I only want to show a cell
if a specific cell is less than my competitors.

I am trying look for trends that I can adjust for and figure the visual
representation will help.

Can anyone help me with this?

Thanks
John