Conditional Formatting

R

rick wintomac

In Excel, is there any way to do conditional formatting that responds
to more than three conditions.

All I need to do is to give a cell one of five colors in the cell
background color, based on the cell's value being in one of five ranges
(thus five conditions required).
 
R

rick wintomac

This string does the font color.

Is there a string I can apply that does the background color?
 

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 formatting if three conditions are true 1
conditional formatting with color- five rows at a time? 1
Excel conditional formatting with Weeknum 4
Conditionnal formatting 1
Conditional Formatting Excel 2003 1
Conditional formatting in Excel_Strange behaviour 6
XL2007: Conditional format repeated 100 times??? 1
How do I format a cell based on conditions in five different cells 1

Top