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?
 
Top