The Excel table automatically expands to include the new rows, and fills in the formulas in column F. So, to save typing time, I copy and paste the headings from the day before.įor example, in the screen shot above, I could copy the regions and products headings from B2:C4, and paste them into cell B10:C12, for the latest day’s data.
In the workbook, I track some daily statistics for my website, and use the same headings every day. The conditional formatting was set for cells A2:F9, and uses a simple formula to see if the date is equal to the date in the row above. The red border really makes the list easier to read, especially if I’m looking at it before my morning coffee! It’s a technique that I use in one of my own workbooks, which I update every morning. It’s useful for alerting people to problems, hiding duplicate values in a column, or even hiding cells’ contents, until related cells are filled correctly.Įarlier this year, I posted a tip for separating dates in a list, by using a red border at the start of a date change. There are lots of ways to use Excel conditional formatting. Fortunately, the fix didn’t take too long, but with complex formatting, things could have been much worse. But this week I ran into a conditional formatting nightmare, and had to start from scratch. I’m a big fan of Excel’s conditional formatting, and often use it to highlight cells on a worksheet.
