Month: March 2018

Convert cell into textbox

Often times, I found myself the need to design a sheet where I want users to input something, and I need them to focus on...

FORMULATEXT to show formulas

Back in the day, we used to need to write a full macro (also called User-Defined-Function) to allow users to show the formula from a...

Highlight dates dynamically

Conditional formatting is another powerful feature in Excel, especially when you combine it with functions A simple function as in below if you set it...

Limited Ceiling

The function CEILING (CEILING.Math as of Excel 2016) is a very good powerful function. It allows you to round  number to any value up Unlike...