Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Show developer tab Excel User tips
  • VALUE() of LEFT() Formulas - combined functions
  • Rotate table using 1 formula ADDRESS
  • Edit directly in cell Excel User tips
  • Count Unique COUNTIF
  • Cells with additional spaces AND
  • GoLast to jump to last cell in a column CELL
  • Multiple lines in cell using 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

  • Show developer tab Excel User tips
  • When Excel functions are not enough Excel User tips
  • Excel ad from early 90s Non-functions
  • Stale values (Scratched functions) Excel User tips
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • Expenses calendar, FaCal Basic Math

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
  • Fx to cut long column into two columns Formulas - combined functions
  • Sheet() and Sheets() Lookup and References
  • Repeated Offset Basic Math
  • Sum of divide – Array formula Array formula
  • Cuts string of list of items Formulas - combined functions
  • Get monthly total from table with dates DATE
  • Blank (isempty) VS “” (null string) Excel User tips
  • SimpleANBox Basic Math

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme