adding more "Conditonal Formatting" options

[Arthur]

I use Excel 2000, and it limits the number of Conditional Formats to 3.
Is there a way to increase this number to, say 10? If not, is there
function similar to conditional formatting that I can use to get th
extra formats I want?

a

 

[Robert Rosenberg]

If you truly have ten different conditions, then only a macro can accomplish
what you want.

If, however, you have one or more conditions that when true get the same
conditional format, you can group them using the "Formula Is" option.

For example, if I want a red font color whenever the number in the cell is
below 100 OR above 1000, I can combine what some might see as two conditions
into one by doing the following:

1. Select the desired cells (in my example, I've selected cells A1:A10)

2. Click Format-->Conditional formatting

3. Change the first DropDown to "Formula Is"

4. Enter the following formula in the box to the right of Formula Is

=OR(A1<100,A1>1000)

Where A1 is the first cell in the selected range

5. Access the Format button and apply the Red Font Color

6. Click OK twice