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.
