Cell Rule Types

Cell Rule Types

Excel offers the following cell rule types:

  • Greater Than…
    Highlights cells with values greater than a specified value.
    • Example: Highlight test scores greater than 90
  • Less Than…
    Highlights cells with values less than a specified value.
    • Example: Highlight inventory counts less than 10
  • Between…
    Highlights cell values between two specified values

    Example: Highlight heart rates between 60 and 100
  • Equal To…
    Highlights cells equal to a specified value.
    • Example: Highlight status cells equal to "Complete"
  • Text That Contains…
    Highlights cells containing specific text
    • Example: Highlight names that contain "Smith"
  • A Date Occurring…
    Highlights dates within a selected time frame
    • Example: Highlight dates from Last 7 Days
  • Duplicate Values
    Highlights values that appear more than once
    • Example: Highlight duplicate student IDs
  • Unique Values
    Highlights values that appear only once
    • Example: Highlight unique email addresses
Back to Lessons Next Lesson →