• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. Applying Number and Date Formats > Creating Custom Conditions Codes

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]


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint