![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |