EXCEL - conditional format

F

FGM

Is it possible to put more than 3 conditional formats?
I want to put around 8... If 0-5 blue, If 6-10 red, If
11 - 15 brown etc....
Thanks....
 
M

Myrna Larson

You'll find that you can't add more than 3 conditions. i.e. the answer to the OP's question is
No. You would have to use an event macro (maybe On_Calculate) to scan the cells and set the
colors if you need more than 3 conditions (plus the default).
 

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

Find value based on two lookup values 2
Conditional Formatting with VBA 4
Paragraph numbering in Word 1
Conditional Formatting - Excel 2003 2
Conditional Formatting Across Multiple Cells 0
Warnings on a certain date 0
Conditional formatting with dates 7
IF AND OR STATEMENT 3

Top