Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • The Excel “&” bug Excel User tips
  • Convert cell into textbox Excel User tips
  • Paste Special Percentage Excel User tips
  • Spreadsheet Compare application Excel User tips
  • Extract Address into table Formulas - combined functions
  • Cells with additional spaces AND
  • Always get 1st name (or last) Formulas - combined functions
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting

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

  • Comments versus Notes Excel User tips
  • Blank (isempty) VS “” (null string) Excel User tips
  • Custom fiscal year calendar (CFlex) Basic Math
  • Recover the unrecoverable Excel User tips
  • Edit directly in cell Excel User tips
  • Stale values (Scratched functions) Excel User tips

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
  • Skills Grid Conditional Formatting
  • CONVERT function CONVERT
  • Get monthly total from table with dates DATE
  • Scorring, saving multiple outputs in 1 number Basic Math
  • Limited Ceiling Basic Math
  • Extract current (Active) workbook name CELL
  • LastSunday, LastSaturday Date and Time
  • CamelCase to Camel Case CHAR

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme