If Statement

Originally Posted by whatsmyname

Okay, this works good, but I have alot more options than just the three it allows me on conditional formatting. Is there a way that I can make it look at that cell and see if it has multiple letters say, "P", "S", "B"?

And if it is either one of those then change the condition.

The fundamental question is whether or not you require more than 4 possible formats for any given cell ?

If the answer to this question is yes and you're running an XL version prior to 2007 then you will need to use VBA rather than Conditional Formatting. The latter as you say limited to 3 (plus standard).

If the format for P, S & B is the same (ie an OR test) then you can modify the rule to:

=AND(OR(LEFT(C1)="P",LEFT(C1)="S",LEFT(C1)="B"),CEILING(N1,6)=6,O1="MONTHS")

or

=AND(ISNUMBER(SEARCH(LEFT(C1&"^"),"PSB")),CEILING(N1,6)=6,O1="MONTHS")

Originally Posted by whatsmyname

Also, what does the "6" mean that is next to the " N1"?

Check out the Help files re: CEILING function - the 6 represents the significance.