ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I create 5 Conditional Formatting rules in Excel 2003? (https://www.excelbanter.com/excel-discussion-misc-queries/189113-how-do-i-create-5-conditional-formatting-rules-excel-2003-a.html)

Antonio

How do I create 5 Conditional Formatting rules in Excel 2003?
 
Excel 2003 allows only 3 rules for Conditional Formatting. I need to use 5
rules, though.

Ron de Bruin

How do I create 5 Conditional Formatting rules in Excel 2003?
 
Hi Antonio

Try this add-in
http://www.xldynamic.com/source/xld.....Download.html

Or upgrade to 2007


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Antonio" wrote in message ...
Excel 2003 allows only 3 rules for Conditional Formatting. I need to use 5
rules, though.


Don

How do I create 5 Conditional Formatting rules in Excel 2003?
 
can you create another column that will combine what you need to compare =
maybe you want a name and location but you can combine these two to analize.
You can also use the formula selection insted of looking at the cell to
analize mult cells

"Antonio" wrote:

Excel 2003 allows only 3 rules for Conditional Formatting. I need to use 5
rules, though.



All times are GMT +1. The time now is 06:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com