Hey,
I have a Conditional Formatting running on my excel sheet which will run slow at times, especially when applied to larger range such as $A$1:$z$1000, however if fewer cells are chosen the same conditional formatting will run perfectly. therefore I was wondering if a Vba could set conditional formatting rule to be applied towards current row only?
For instance I have a formula (Rule)
=CELL("row")=ROW()
which is applied on =$A$1:$z$1000
vba:
gets applied on = current row
will appreciate any help.
thank u.
I have a Conditional Formatting running on my excel sheet which will run slow at times, especially when applied to larger range such as $A$1:$z$1000, however if fewer cells are chosen the same conditional formatting will run perfectly. therefore I was wondering if a Vba could set conditional formatting rule to be applied towards current row only?
For instance I have a formula (Rule)
=CELL("row")=ROW()
which is applied on =$A$1:$z$1000
vba:
gets applied on = current row
will appreciate any help.
thank u.
Last edited: