Excel – If cell is not blank (Formula & VBA)
In this article we will see how we can identify, and operate in different ways, blank cells directly in formulas and VBA code. Read More …
Tag: cell
Excel – Conditional Formatting based on another Cell
When you want to format a cell based on the value of a different cell, for example to format a Read More …
Create Barcode without Third Party Software (Microsoft Excel)
A barcode is a series of lines with varying width that hold any type of information. Nowadays, barcode has been Read More …
Add/Insert Leading Zeros To Numbers Or Text (Microsoft Excel)
Supposing you need to input some zip codes or phone numbers in cells of Excel, then you will find Microsoft Read More …
Cell Shows ##### (Excel)
Sometimes, when you enter a formula into Excel, the cell simply shows #####, instead of the expected value. Possible Reason Read More …