Hello,
I'm try to devise a conditional formatting formula that will highlight all sequential values in a row. Have tried several variations of this formula (which finds dupes) without success:
=COUNTIF(A$7:F$7,A7)>1
Am aware that the solution can be done in VB but writing something from scratch is a bit outside my realm of skill.
Any suggestions or pointers would be very much appreciated.
-Ommni
I'm try to devise a conditional formatting formula that will highlight all sequential values in a row. Have tried several variations of this formula (which finds dupes) without success:
=COUNTIF(A$7:F$7,A7)>1
Am aware that the solution can be done in VB but writing something from scratch is a bit outside my realm of skill.
Any suggestions or pointers would be very much appreciated.
-Ommni