Help please, this is really frustrating me
I have a time in cell I1 - When I put a single figure greater than 0 in any cell between I2 & I30 I want cell I1 to change colour.
I can get I1 to change colour if I put a figure into I2 it but not if I put the figure in any other cell in the column - I have tried =$I$2:$I$30>0 and tried moving the $ around but to no avail which is making me think I have taken completely the wrong approach.
Any help would be greatly appreciated
Bookmarks