Can I use more than three conditions for conditional formating?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way around just being able to use conditional formatiing on only
three conditions... I want to use 5 or 6?
 
Is it 5 or 6 "conditions" that you want? or 5 or 6 "formats"?

Conditional Formatting is limited to 3 formats (4 if you count the default
format of your cell). However, the number of conditions can be several with
the help of the AND and OR functions.

If you do indeed need 5 or 6 formats, then you'll probably need to pursue a
VB option. If you provide examples of what you want to accomplish, we might
be able to provide a solution.

HTH,
Elkar
 
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

Excel Conditional Formatting 1
Conditional Formatting 3
Conditional Format 8
Returning a value if multiple conditions are met 2
Conditional formats using more than 3 conditions 2
Conditional formatting if three conditions are true 1
Conditional Highlight 16
Conditoinal formatting 2

Back
Top