|Subject:||Conditional Format (exclude 0)|
|Date:||Fri, 24 Aug 2007|
Excel2003 ... Range A6:G6 contains Formula's
Cell A6 contains a Name (returned by formula)
Range B6:G6 contains values 0 to 7 (returned by formula & may repeat)
I wish to set conditional formatting in Cell A6
Condition = when value in Range B6:G6 is >=1 & <5.
Thanks ... Kha