Hi!
If the default fill color is white then you only have 3
conditions: red, yellow, green.
If the default fill color is in fact something other than
white, then yes, you do have 4 conditions. If that's the
case, you need VBA code.
Check out this newly developed add-in that's just for
situations like this. It allows up to 30 conditions.
http://xldynamic.com/source/xld.CFPlus.Download.html
Biff
-----Original Message-----
I need to set up conditional formatting on a group of
cells such that Less
than or equal to the lower limit is RED, Between the
lower and Upper limit is
Yellow, Greater than or equal to the upper limit is
green, and finally if the
cell is blank, then make the fill color white , (or no
color)
Thanks,
Junior
.