Waffle Chart In Excel - Excel Tips and Tricks Let me show you how I can create a waffle chart in Excel. Here's the formula feature in my video. Numbering =SEQUENCE(10,10,0.01,0.01) For Microsoft 1) Select F7 2) Conditional Formatting ~ Manage Rule 3) New Rule... 4) Format only cells that contain 5) Cell value, Less than or equal to, =$D$6 6) Format 7) Fill tab 8) Color = Blue 9) OK 10) OK For Google And Apple 1) New Rule... 2) Format only cells that contain 3) Cell value, Less than or equal to,

Four Ways to Show Formula using FORMULATEXT Function in Excel

Excel shows formula as text INSTEAD of the result of the formula #youtubemadeforyou

Formula Text Displayed Instead of Result