Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior
 
Posts: n/a
Default Conditional Formatting Blank =white.. but 4 conditions

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
  #2   Report Post  
Biff
 
Posts: n/a
Default

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
.

  #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
.


  #4   Report Post  
Biff
 
Posts: n/a
Default

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

-----Original Message-----
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
.


.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
More than 3 Conditional Formatting Conditions Beth H Excel Worksheet Functions 12 January 6th 06 08:35 PM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 04:33 PM
conditional formatting blank cell TREK5200 Excel Discussion (Misc queries) 1 December 6th 04 03:23 AM
Adding more than three Conditions to 'Conditional Formatting' David McRitchie Excel Discussion (Misc queries) 1 November 27th 04 07:03 PM
Extend conditional formatting to more than 3 conditions Danny Excel Worksheet Functions 1 November 10th 04 11:57 AM


All times are GMT +1. The time now is 10:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"