View Single Post
  #3   Report Post  
Junior
 
Posts: n/a
Default

Thanks Biff,
I saw reference to this add on in other messages but I shyed away from it
because I'm thinking that the conditional format would not remain, when I
sent the spreadsheet to someone that did not have the add-on installed on
their machine. Do you know if this is the case or not??

Junior.

"Biff" wrote:

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
.