Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Sort list dynamically (functions) COLUMN
  • Excel @ before function names in formulas Excel User tips
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Workdays – Across months DATE
  • Unix DateTime Number Basic Math
  • Tally chart in functions Formulas - combined functions
  • Always get 1st name (or last) Formulas - combined functions
  • Formula Beautifier Excel User tips

Shapes with dynamic output

Posted on July 18, 2022 By ANmar

A trick learned awhile ago. Creating shapes connected to cell, that updated automatically.

When following steps attached, you will be able to connect any shape to any cell in away making it “linked”, so when cell changes the shape will also get updated.

Used it to enlarge or track user attention to a certain value, or sometimes to format certain text in a free way outside cells limitations.

See it in action …

Download
Excel Online
Excel User tips, Graphics, Non-functions Tags:dynamic, link, shape, shapes

Post navigation

Previous Post: The Excel “&” bug
Next Post: Min Max vehicle

Related Posts

  • Spreadsheet Compare application Excel User tips
  • CTRL+Y a mini macro Excel User tips
  • Scorring, saving multiple outputs in 1 number Basic Math
  • Excel @ before function names in formulas Excel User tips
  • Show developer tab Excel User tips
  • Excel ad from early 90s Non-functions

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

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 (83)
    • 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 (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • 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 (6)
      • Average (1)
      • 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
  • Sort list dynamically (functions) COLUMN
  • The Excel “&” bug Excel User tips
  • Excel Functions = XL f(x)s XLfxs
  • Stale values (Scratched functions) Excel User tips
  • Blank (isempty) VS “” (null string) Excel User tips
  • Schedule column Basic Math
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • When Excel functions are not enough Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme