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 that particular single input (or …

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 up inside Conditional formatting, can …

Multiple Dual-Validations

It is to demonstrate how to do multiple validations in the same sheet, or as we want to call it Mutliple-dual-validations that depend on each other. Checking out sheet “Data”, …