When you delete a row, the row below that loses its reference to that row. It compares the date in the current row, to the date in the row above: The new rule was created because the Top Border rule has a formula that refers to another row.
There is a new rule that applies to row 10 only, and it has a #REF! error. The original rule has changed, and excludes the deleted row. Then, go to Conditional Formatting > Manage Rules, to see the results. To see how a new rule is automatically created, delete row 10 in this table. In columns A:E, add a blue top border if the date in column A is different from the date above. In column E, highlight prices that are greater than 500. In this example, there is a small table, with 2 simple conditional formatting rules: It’s designed for data in in an Excel named table. If you need to do this frequently, go to my website to get a macro that removes the duplicate rules. There are written instructions below the video. Watch this video to see how the duplicated rules are created, and an easy way to fix the problem. Video: Conditional Formatting Duplicated Rules Conditional formatting is a great way to highlight specific data, but did you know that it can automatically create new rules on its own? I’ll show you how that happens, and an easy way to fix those conditional formatting duplicated rules.
0 kommentar(er)
