Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Count cells with condition – multiple conditions COUNTIFS
  • Schedule column Basic Math
  • Scorring, saving multiple outputs in 1 number Basic Math
  • Standard math to calculate Aspect Ratio Basic Math
  • Cuts string of list of items Formulas - combined functions
  • GoLast to jump to last cell in a column CELL
  • Unix DateTime Number Basic Math
  • Insert Blank rows into table using functions CHAR

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

  • Scorring, saving multiple outputs in 1 number Basic Math
  • Custom fiscal year calendar (CFlex) Basic Math
  • Shades of gray Graphics
  • Skills Grid Conditional Formatting
  • Excel @ before function names in formulas Excel User tips
  • Spreadsheet Compare application 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
  • Count cells with condition – multiple conditions COUNTIFS
  • 6174 Kaprekar’s constant Basic Math
  • Calculate hours between two cells ABS
  • Excel Dynamic Drop-Downs that grow with you COUNTA
  • Hyperlink usage and HyperlinkOf UDF CELL
  • Show developer tab Excel User tips
  • Shades of gray Graphics
  • Change Calculator – calculate change in multiple bills/coins Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme