Hi,

I have 3 columns of data 10 rows long. (A-C ; 1-10). What I want to do is add Conditional Formatting to cells B1:B10 and C1: C1:C10 based on what's in A1:10 and B1:10 respectively.

So if B1 is less than A1 give me a down arrrow (or whatever) and if C1 is greater than B1 give me an up arrow.

I can do them all individually but is there a way to highlight all cells and apply a formula? I have quite a lot...

Thanks.