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