Conditional Formatting Blank =white.. but 4 conditions

[Guest]

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

 

[Biff]

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

 

[Guest]

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]

Hi!

I'm not sure about that. The add-in may create event
procedures that stay with the file. But I don't know,
that's just a wild guess. Also, I don't have this add-in
myself.

Try searching the google archives for "conditional
formatting more than 3 conditions". I've seen lots of code
examples for this over the years. I myself am not a coder
so I can't help with that.

Biff