How to Highlight Excel Cells Outside Minimum or Maximum Limits
Question details
The user wants to emphasize or highlight spreadsheet cells that contain values falling below a minimum threshold or above a maximum threshold, avoiding distracting flashing effects.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Data validation and visually flagging outliers or out-of-bounds values in a dataset.
- Observed behavior
- A need to securely and simply format cells to flag values outside a specific allowed range instead of making them blink or flash.
Ensure your dataset is properly organized and clearly define your minimum and maximum threshold values in separate reference cells before applying formatting rules.
Use Conditional Formatting with an OR Formula
Apply a custom formula within conditional formatting to efficiently highlight values that are either too low or too high in one single rule.
Using a custom formula for conditional formatting is the most dynamic way to highlight outliers. It avoids inaccessible flashing effects and instantly updates if your data or limit thresholds change.
Highlight all the cells containing the data you want to monitor (for example, select cells A2 to A100).
Navigate to the Home tab on the ribbon, click on 'Conditional Formatting', and select 'New Rule' from the drop-down menu.
Choose 'Use a formula to determine which cells to format'. Enter the formula =OR(A2<$B$1,A2>$B$2), assuming B1 contains your minimum limit, B2 contains your maximum limit, and A2 is the first cell in your selected range.
Click the 'Format' button and choose a distinct fill color, bold font, or noticeable border. Click 'OK' to apply the rule to your dataset.

Use Built-in Highlight Cell Rules
Quickly set up two separate rules using the standard Highlight Cell Rules menu without writing any formulas.
Easily Highlight Outliers in WPS Spreadsheet
WPS Office provides a powerful, free Spreadsheet tool that fully supports advanced conditional formatting. You can easily highlight cells that fall outside specific minimum and maximum limits using formulas or built-in rules, helping you spot data anomalies instantly.
- 1. Open your spreadsheet in WPS Office: Launch WPS Spreadsheet and open your .xlsx file containing the data you want to format.
- 2. Locate Conditional Formatting: Highlight your data range, then go to the Home tab and click on the 'Conditional Formatting' icon.
- 3. Apply the Highlight Rule: Click 'New Rule', choose 'Use a formula to determine which cells to format', and input your threshold formula (e.g., =OR(A1<$B$1,A1>$B$2)) to highlight the out-of-bounds data instantly.

Frequently Asked Questions
Can I make the highlighted cells flash or blink instead?
It is highly recommended to avoid flashing or blinking cells. Making cells flash requires VBA macros, which can slow down your workbook. More importantly, flashing elements pose severe accessibility risks, particularly for users with photosensitive epilepsy. Simple color-based conditional formatting is safer, more professional, and easier to implement.
Why isn't my conditional formatting formula working correctly?
Ensure you are using absolute references (with $ signs, like $B$1) for your limit cells and relative references (without $ signs, like A1) for the first cell in your selected data range. If you selected A2 as the first cell in your range, your formula must start with A2, otherwise the formatting will offset incorrectly.
Can I use different colors for minimum and maximum limits?
Yes. Instead of using a single OR formula, you can create two separate conditional formatting rules for the same range. Create one rule for 'Less Than' your minimum limit with one color (e.g., blue), and a second rule for 'Greater Than' your maximum limit with a different color (e.g., red).
Will my conditional formatting rules be saved if I share the file with Excel users?
Yes, if you save your file in the standard .xlsx format using WPS Spreadsheet, all your conditional formatting rules and formulas will be perfectly preserved and will work seamlessly when opened in Microsoft Excel.




