Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Blank (isempty) VS “” (null string) Excel User tips
  • Multiple lines in cell using functions CHAR
  • The Excel “&” bug Excel User tips
  • CTRL+Y a mini macro Excel User tips
  • Recover the unrecoverable Excel User tips
  • Progress bar in pure functions CHAR
  • Sheet() and Sheets() Lookup and References
  • Insert Blank rows into table 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

  • CTRL+Y a mini macro Excel User tips
  • Excel ad from early 90s Non-functions
  • Excel sessions – 2013 VS 2010 Excel User tips
  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • Excel keeps converting all cells to “Date” (or Time) 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
  • Multiple lines in cell using functions CHAR
  • Extract current (Active) workbook name CELL
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF
  • Week number to Sunday date – Weeknum reverse DATE
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Shapes with dynamic output Excel User tips
  • Filter. Google Sheets function Google Sheets
  • Highlight dates dynamically AND

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme