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
Try this...
=COUNTIF($I$2:$I$30,">0")
If the result is any number other than 0 the format will be applied.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks Tony, that's great, works a treat
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks