Get
Digital
Help
More
  • Home
  • Functions
    Functions A to Z Functions by category
  • Formulas
  • Features
    Excel Basics Excel Defined Table Advanced Filter Data Validation Drop-down lists Named Ranges Solver
  • Charts
  • Conditional formatting
  • Pivot table
  • VBA
    VBA Functions Methods Properties Statements Macros User defined functions Files & folders Checkboxes
  • Archive
    All articles Products
  • Contact
    About me Blogs I read

    Conditional formatting

    Data Bars

    Color Scales

    Icons sets


    Highlight cells rules

    Equal to

    Text that contains

    A date occuring ...

    Unique/duplicates


    Top bottom rules

    Top 10 items

    Top 10 %

    Above average


    Basic formulas

    Overview - CF formulas

    Highlight empty cells

    Highlight text values

    Numbers in range


    Search

    Highlight lookup values

    Records [AND logic]

    Records contain [AND]

    Records [OR logic]


    Unique distinct

    Based on a column

    Based on a cell range

    Highlight records

    Filtered Excel table


    Duplicates

    Based on a column

    Two columns

    Based on cell range

    Records

    Based on date

    Date, week, month

    Duplicate columns

    Min duplicate number

    Filtered Excel table


    Compare

    Two columns (common)

    Two cols (difference)

    Missing values (2 cols)

    Unique records

    Common records

    Two price lists


    Min max

    Closest number

    Based on month

    Min duplicate number


    Dates

    Highlight weekends

    Based on day of week

    Date range

    Overlapping date rngs

    Overlap rngs - condition

    Highlight current date

    Based on month

    Odd/even months


    Formatting


    Misc

    Every other row

    Based on coordinates

    Dynamic formatting

    Opposite numbers

    Drop-down selector

    Highlight cells based on ranges




  • Search website

Privacy PolicyNo AI