Formatting Issues

How to Conditionally Format Unique Fractional Odds in Excel

Tauseeq Magsi Oct 12, 2026 869 views

Question details

The user needs to highlight unique or duplicate fractional odds, such as 5/4, 2/2, 100/30, and 20/1, within a specific Excel column.

How to Conditionally Format Unique Fractional Odds in Excel

Product: Excel
Device & OS: not provided
Scenario: Organizing and analyzing datasets containing betting odds or mathematical fractions, where identifying standalone (unique) or repeating (duplicate) values is necessary.
Observed behavior: The user wants to apply a cell format that automatically highlights the targeted unique or duplicate fractional values for easier visual identification.

Before you start

Ensure your fractional odds are entered as text or properly formatted fractions in your spreadsheet so they are not accidentally converted into dates by the system.

Solution 1Recommended

Use Built-in Conditional Formatting for Duplicate and Unique Values

This is the quickest and most efficient way to highlight specific unique or duplicate fractional odds using the software's built-in formatting rules.

Excel includes a native Highlight Cells Rule specifically designed for finding duplicate and unique values. This method requires no formulas and can be applied in just a few clicks.

Select the data range

Click and drag to select the column or specific cells containing your fractional odds.

Navigate to Conditional Formatting

Go to the 'Home' tab on the top ribbon, locate the 'Styles' group, and click on 'Conditional Formatting'.

Choose the Highlight Cells Rule

Hover your mouse over 'Highlight Cells Rules' in the dropdown menu, then click on 'Duplicate Values...'.

Configure the highlighting

In the dialog box that appears, click the first dropdown to choose either 'Unique' or 'Duplicate'. Select your preferred color formatting from the second dropdown, then click 'OK' to apply the rule.

Use Built-in Conditional Formatting for Duplicate and Unique Values

Custom Formatting: If you do not like the default highlight colors, you can select 'Custom Format...' from the color dropdown to choose specific fonts, borders, or fill colors.

WPS Spreadsheet Solution

Highlight Unique or Duplicate Values Easily in WPS Spreadsheet

WPS Spreadsheet provides a highly intuitive and fully compatible Conditional Formatting tool, allowing you to identify unique and duplicate fractional odds instantly without complex formulas.

1. Select your data: Open your spreadsheet in WPS Office and highlight the column containing your fractional odds.
2. Open Conditional Formatting: Go to the Home tab and click on the 'Conditional Formatting' button.
3. Choose Highlight Rules: Select 'Highlight Cells Rules' and then click on 'Duplicate Values'.
4. Apply formatting: Choose 'Unique' or 'Duplicate' from the prompt window, pick a color scheme, and click OK.

Fully compatible with Microsoft Excel file formats (.xlsx, .xls).Built-in 'Highlight Cells Rules' for managing unique and duplicate data.Lightweight software with a familiar, easy-to-navigate interface.Free to use for everyday data analysis and formatting tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Why are my fractional odds formatting as dates instead of text?

If you enter a fraction like 5/4, the spreadsheet may automatically convert it to a date (e.g., May 4). To prevent this, select your column and format it as 'Text' before entering the odds, or type an apostrophe (') before the fraction (e.g., '5/4).

Can I highlight both unique and duplicate values at the same time?

Yes, you can apply two separate Conditional Formatting rules to the same range of cells. Simply go through the steps once to highlight 'Unique' values with one color, and repeat the process to highlight 'Duplicate' values with a different color.

How do I remove the conditional formatting from my odds?

Select the formatted cells, navigate to the Home tab, click 'Conditional Formatting', select 'Clear Rules', and then choose 'Clear Rules from Selected Cells'.

Document & File Issues