Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Master
 
Posts: n/a
Default limited conditional formatting?

Hi!

I'm currently using MS Excel 2000. Is there really just 3 conditional
formattings? I want to apply 5 conditional formattings on my sheet, is there
any way to do that?

Thanks!
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

Your limit is 3. The alternative is to use VBA, or
download this free add-in found on Bob Phillips' site:

http://www.xldynamic.com/source/xld.....Download.html

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi!

I'm currently using MS Excel 2000. Is there really just

3 conditional
formattings? I want to apply 5 conditional formattings

on my sheet, is there
any way to do that?

Thanks!
.

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
why am i limited to only 3 conditional formatting? yigalb Excel Discussion (Misc queries) 4 February 12th 05 04:46 AM
Conditional Formatting is limited to 3 conditions, any way I can . Fred Stoll Excel Worksheet Functions 1 February 11th 05 12:22 AM
Copy conditional formatting across multiple rows? Gil Excel Discussion (Misc queries) 1 January 11th 05 11:27 AM
Determine cells that drive conditional formatting? Nicolle K. Excel Discussion (Misc queries) 2 January 7th 05 01:08 AM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM


All times are GMT +1. The time now is 05:28 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"