artsjeroen
New Member
- Joined
- Mar 18, 2014
- Messages
- 5
I've created a rule in conditional formatting to format rows based on duplicate values using this formula:
=ISODD(SUMPRODUCT(1/COUNTIF($A$1:$A2,$A$1:$A2)))
Which works nice but excel freezes when scrolling through my sheet.
Is there another way which is 'lighter'? Or VBA perhaps?
=ISODD(SUMPRODUCT(1/COUNTIF($A$1:$A2,$A$1:$A2)))
Which works nice but excel freezes when scrolling through my sheet.
Is there another way which is 'lighter'? Or VBA perhaps?
