Get Digital Help
  • Home
  • Templates
  • Products
  • Functions
  • Archive
  • Contact
    • Contact me
  • About Me
    • About me
    • Blogs I read
    Function Reference Formulas Charts Conditional Formatting Excel Tables Pivot Tables VBA Knowledge Base Macros User Defined Functions Videos Advanced Excel Course

    Most used functions

    COUNTIF function INDEX function IF function SUM function SUMIFS function SUMPRODUCT function VLOOKUP function


Archive for Conditional formatting


Highlight cells based on coordinates
Highlight opposite numbers
Highlight empty cells
Compare two columns and highlight differences
Track progress
Highlight unique values in a filtered excel table
Counting conditionally formatted cells (vba)
Highlight date ranges overlapping selected record [VBA]
Highlight duplicates in a filtered Excel defined table
Drop down list changes cell formatting
Shift Schedule
Highlight numbers within specific ranges
Working with Conditional Formatting formulas
Highlight lookup values
How to highlight differences in price lists
Highlight records [AND logic]
Highlight records – multiple criteria [OR logic]
Highlight closest number
Highlight duplicate columns
Highlight duplicate records
Highlight duplicates with same date, week or month
Highlight odd/even months
Highlight duplicates based on criteria, part 2
How to highlight MAX and MIN value based on month
Highlight more than once taken course in any given day
Highlight unique distinct values in two cell ranges
Highlight duplicate values in two cell ranges combined
Highlight smallest duplicate number
Highlight duplicate values in a cell range
Highlight unique values and unique distinct values in a cell range
Highlight duplicates in two columns
Compare two columns and highlight values in common
Dynamic formatting
Highlight missing values between to columns
How to highlight duplicate values
Highlight every other row
Highlight dates in a date range
Highlight duplicates based on criteria, part 1
How to highlight unique distinct values

      Formula categories

      Count

      Dates

      Extract

      Index and Match

      Logic

      Lookups

      String manipulation

      Sum

      Time

      Vlookup

  • Welcome! I am Oscar and here to help you! Feel free to comment and ask excel questions.
    Don´t forget to add my RSS feed and subscribe to new blog articles by email.

  • Free Blog Emails

     

  • Search website

sponsored