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 colu...
- 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.
- Thank you SergeiBaklan, HansVogelaar.
This has corrected the issue. I spent a lot of time trying to get the right formula from many different sites dedicated to excel and these sorts of things. This answer was not on any of those sites.
