more than 3 formatting conditional

  • Thread starter conditional formatting - more than 3
  • Start date
C

conditional formatting - more than 3

I'm aware that excel 2000 limits conditional formatting to 3 conditions. I
would like to use 5. I have a column with data anda i want the next column
have a color depending on data . If value data is less than 25,then fill
color = blue; if value data is between 25.1 and 3, then fill color = green;
if value data is between 40.0 and 30.1, then fill color = yellow; if value
data is between 80.0 and 40.1, then fill color = orange, and if value data is
greater than 80.0, then fill color=red. How can I get around the limit of 3
conditional formatting conditions?
 

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

To find Maximum value using conditional formatting 2
Conditional formatting dates 3
Conditional format question 4
Conditional Formatting with VBA 4
Cobditional Formatting Rows based on dates in action plan. 0
Excel 2010 Conditional Formatting 2
Conditional Formatting from a group 6
Excel Popup box to fill a row 0

Top