Hi,

I'm having trouble applying conditional formatting to a large selection of data and would appreciate any assistance available.

I have multiple columns of data, and essentially what I want to "highlight" is: If one cell is greater (or less) than zero and the other cell which I'm conditionally formatting = 0% highlight the cell I'm conditional formatting.

The issue I have is that I want to check that we are not missing income, and if the sales figure is either positive or negative, then the cell (% figure) should not be zero.

Hopefully this makes sense.

Thanks,
Greg