Hi Anthony

If you want to color 0's change the 1st condition formula to

=AND(G3+0=0,G3+0<250)

If this post helps click Yes
---------------
Jacob Skaria


"Anthony96960" wrote:

Thanks Max that worked a treat
The only ones that arn't coloured are the ones that equal zero, which is ok
Thanks again

"Max" wrote:

Errata, this line should have read:
Cond1: =AND(G3+00,G3+0<250)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---