Contitional Formatting

  • Thread starter Thread starter reche81
  • Start date Start date
R

reche81

In excel 2000 Can I use 4 conditional formats instead of 3, and how do
do it
 
No but there are workarounds using AND/OR or macros such as select case
 
There is always a fourth CF........Excel default.

So, you can have Red, Green, Blue and default.

Any more than that would require the use of Code.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formating 3
Conditional formatting if three conditions are true 1
Editing conditional formats (Excel 2010) 15
Conditional Formatting based on dynamic Date 1
Formating lost when cut and insert 2
Code for conditional formatting 5
Excel Conditional Formatting 1
How can I apply conditional formating for cells in different file. 2

Back
Top