Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Cuts string of list of items Formulas - combined functions
  • CTRL+Y a mini macro Excel User tips
  • Skills Grid Conditional Formatting
  • New function IFERROR, finally IFERROR
  • Zipcode-State search Formulas - combined functions
  • Sort list dynamically (functions) COLUMN
  • Excel sessions – 2013 VS 2010 Excel User tips
  • Formula Beautifier Excel User tips

Highlight dates dynamically

Posted on March 14, 2018 By ANmar

Conditional formatting is another powerful feature in Excel, especially when you combine it with functions

A simple function as in below if you set it up inside Conditional formatting, can do magic

 

Attached spreadsheet below has two examples of how to use that formula to highlight the dates needed, you just need to think about the condition in your AND function, and then you good to go

Example below will highlight columns B to E when cell in E is in the future and within the next 7 days

Conditional formatting variable related.png

 

Download spreadsheet
Excel Online version
AND, Conditional Formatting, Non-functions, Standard functions, TODAY

Post navigation

Previous Post: Excel ad from early 90s
Next Post: IFS (and IFNA) to avoid nested IFs

Related Posts

  • Schedule column Basic Math
  • IF with AND and IF with OR AND
  • Paste Special Percentage Excel User tips
  • Expenses calendar, FaCal Basic Math
  • Blank (isempty) VS “” (null string) Excel User tips
  • MID + SEARCH to convert cell to rows MID

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Cells with additional spaces AND
  • Middle name + 1st name Basic Math
  • Unix DateTime Number Basic Math
  • Excel sessions – 2013 VS 2010 Excel User tips
  • Hello world! Uncategorized
  • Count how many times letter found Formulas - combined functions
  • Rotate table using 1 formula ADDRESS
  • Search across sheets in function ADDRESS

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme