adding a 4th conditional format in Excel

[Micksxboxmods]

Hi Guys,
Anyone know of a way to add a 4th conditional format in excel without having to use addons???
Cheers
Mick

[ozchips]

Select your range of cells.

Click Conditional Formatting on the Format menu.

Under Condition 1, in the first two boxes, choose Cell Value Is and less than or equal to. Then type the value -25 in the third box.

Now click the Format button, choose a red fill color from the Patterns tab, and then click OK.

Click Add. Under Condition 2, choose between in the second box, type the values to 0 and -25 in the third and fourth boxes, and then choose a yellow fill format.

Click Add again. Under Condition 3, choose between in the second box, type the values to 0 and 25 in the third and fourth boxes, and then choose a green fill format.

Click OK to close the Conditional Formatting dialog box.

Finally, while your range is still highlighted, choose a black fill from the color palette.


Your range is now pseudo-conditionally formatted to cover all four cases.

[Micksxboxmods]

Select your range of cells.

Click Conditional Formatting on the Format menu.

Under Condition 1, in the first two boxes, choose Cell Value Is and less than or equal to. Then type the value -25 in the third box.

Now click the Format button, choose a red fill color from the Patterns tab, and then click OK.

Click Add. Under Condition 2, choose between in the second box, type the values to 0 and -25 in the third and fourth boxes, and then choose a yellow fill format.

Click Add again. Under Condition 3, choose between in the second box, type the values to 0 and 25 in the third and fourth boxes, and then choose a green fill format.

Click OK to close the Conditional Formatting dialog box.

Finally, while your range is still highlighted, choose a black fill from the color palette.


Your range is now pseudo-conditionally formatted to cover all four cases.

sorry Chippy, should of said 4 or more.
I've found a great little addon that allows up to 30 conditional formats Will just use that as I have to write a macro to do the formatting of a very large spreadsheet.

[ozchips]

ahh is ok mate , I needed to do the same thing a few years back but only needed a 4th
found that on some website and it worked well , luckily I copied and pasted it , wish I knew the orginal site though