Creating Custom Conditions Codes

Excel allows you to create custom conditions. Another alternative might be to use the conditional formatting feature; however, you can also write your own custom condition codes. Codes or conditions must be enclosed in square brackets and the conditions are separated by a semicolon. For example, if you wanted to create a custom condition based on values below or equal to 50 and greater than 50, you could type the following condition codes into the Type format bar from the format cells dialog box under the Category Custom:

[Cyan][<=50];[Blue][>50]