Forum Discussion

alex2476's avatar
alex2476
Copper Contributor
Jul 04, 2023

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

 

  • mtarler's avatar
    mtarler
    Silver Contributor
    it 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)?

Resources