Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Sorting with functions only CHOOSE
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Worksheet name, dynamically using formula CELL
  • Week number to Sunday date – Weeknum reverse DATE
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Validation based on another Validation COUNTA
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • Progress bar in pure functions CHAR

Shades of gray

Posted on January 25, 2019 By ANmar

We need this to be documented s8mewhere

So, here it is

This is the differences between gray and black color with transparency.

I do see how this is more apparent to end user.

Graphics, Non-functions, Worksheet Tags:color, gray, shade

Post navigation

Previous Post: Recover the unrecoverable
Next Post: DayName

Related Posts

  • SimpleANBox Basic Math
  • Custom fiscal year calendar (CFlex) Basic Math
  • Show developer tab Excel User tips
  • Comments versus Notes Excel User tips
  • Convert cell into textbox Excel User tips
  • WorksheetName and WorksheetsNo UDFs Lookup and References

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
  • Always get 1st name (or last) Formulas - combined functions
  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • Dynamic selection list ActiveX controls
  • Sort list dynamically (functions) COLUMN
  • Recover the unrecoverable Excel User tips
  • IF with AND and IF with OR AND
  • Show developer tab Excel User tips
  • Skills Grid Conditional Formatting

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme