The NOW formula returns the current date and time. It can be applied easily by just typing =NOW()
The OFFSET formula is a very powerful, but unfortunately not easy to understand formula. It basically refers to another cell or cell range. You specify a starting point (“Reference”) from which you count rows and columns. If the starting point is cell A1 and you tell Excel to count 2 cells to the right and 3 down, it’ll return the reference to cell.
You want to display today’s date? Or you want to check, if a date written in a cell is today? There is an easy formula: =TODAY()
One advanced scenario of Conditional Formatting is to use formulas to determine the format. Let’s say, you want to change the background color of cell A if cell B has a certain value.
Let’s assume, we have the following (although realistic) challenge: We got two lists which should have the same items in Excel. But they aren’t exactly the same so that we need to compare them. But how do we find out the best way, which items are missing in either one of the lists? Instead of… Continue reading How to Compare Two Lists in Excel