Forum Discussion
alex2476
Jul 04, 2023Copper Contributor
Changes in conditional formatting
Hello,
There was a change in Excel and some conditionnal formatting isn't working the same.
I have this macro in the page:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Application.CutCopyMode = False Then
Application.Calculate
End If
End Sub
And the conditionnal formatting is :
=OR(CELL("col")=COLUMN(),CELL("row")=ROW())
Now it used to be that only the line (vertical and horizontal) would change color when i clicked but now, the whole area (vertical and horizontal area) goes to white.
I dont see any option to make the line transparent. If i put no fill it still goes to blank and i have color codes to help me with things.
Screenshots included.
Notice in the "when clicked" Image, ive put a square on the grey area which stays the same color even if the vertical and horizontal lines are all go to white. That would be the objective for the whole sheet.
Any help is welcome, thanks
- mtarlerSilver Contributorit is hard to say without having the file, but one question/guess. Are those other fill colors also based on conditional formatting rules? If so it maybe be due to the order of those rules and if 'stop if true' is clicked. any chance you can share a sample sheet (with no private info)?