Get Around Excel's Three-Criteria Limit for Conditional Formatting You can use VBA to hack conditional formatting
to use more than three criteria on your data. In fact, you can use
the code to apply virtually an unlimited number of
criteria [Discuss (0) | Link to this hack]