1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL

  • Conditional Formating

    From Saxman@21:1/5 to All on Mon Apr 11 15:22:35 2022
    I have unique values in a column which I wish to highlight.
    They are fractional odds. Namely,
    40/1
    50/1
    66/1
    100/1
    150/1

    I assume I choose,

    Conditional formatting.
    New rule.
    Use a formula to determine which cells to format.
    Format values where this formula is true.

    I'm not sure what formula I should use in the field.

    TIA

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)