Forum Discussion
Solved
Conditional format malfunction
I have a conditional format that is sort of working. The format is applying the borders seen below. It should be applying them to all the cells to the right of columns A & B for all rows where column B is not blank. You can see that it is but it sort of falls apart towards the end.
Column B contains the values from a dynamic range and can expand and contract as needed. I don't know how to fix this so all the cells in columns C - I and rows B7 - the last populated row have the border properly applied.
5 Replies
- Currently it's =OR(NOT(ISBLANK(B7:B100))) as the range will grow or shrink if more data is added. Also once it malfunctions, it won't change again, even if I delete the conditional formatting rule. It's very bizarre.
Use the formula proposed by SergeiBaklan. Excel will automatically adjust it when it applies the rule to the rows below.
