excel help

AndyRat

GordonD wrote:

I don't believe that is correct, you can format the fonts as well, but only within the 3 conditions. It doesn't give you 3 more conditions


Custom number formats give you additional formatting options.......see below from MS Excel Help

You can specify up to four sections of format codes. The sections, separated by semicolons, define the formats for positive numbers, negative numbers, zero values, and text, in that order. If you specify only two sections, the first is used for positive numbers and zeros, and the second is used for negative numbers. If you specify one section, all numbers use that format. If you skip a section, include the ending semicolon for that section.

By combining these with Conditional Formatting, your options are increased, e.g. use the custom formatting for negatives and zero values and conditional for three more.....

HTH

maxamos

Thankyou everyone for you're help

I've managed to create a worksheet that does everything I want it too, I don't think it's the most elegant piece of of spreadsheet creating but it works.

Just got to show it to the bosses now to see what they think.

Thanks again

Max