JohnZ1156
Board Regular
- Joined
- Apr 10, 2021
- Messages
- 160
- Office Version
- 2021
- Platform
- Windows
I have a column with consecutive numbers. I used “Conditional Formatting” to format a cell if there is a number that is not consecutive in the column.
This is my Conditional Formatting rule description: =AND(A18<>A17+1, A19<>A18+1).
It changes the format to fill “Red, Accent 2, Lighter 40%”.
Right now, I have to scan down 7000+ rows to check to see if there is a number in a cell that is not consecutive by looking for the format changed cell..
Question:
Is there a formula that I can place in a cell outside this column that will tell me if a cell within the column has this “Red, Accent 2, Lighter 40%” format,
and better yet, which row the non-consecutive cell is in?
A formula that constantly looks in the column would be better than VBA, but I can use all the help I can get.
Thank you.
This is my Conditional Formatting rule description: =AND(A18<>A17+1, A19<>A18+1).
It changes the format to fill “Red, Accent 2, Lighter 40%”.
Right now, I have to scan down 7000+ rows to check to see if there is a number in a cell that is not consecutive by looking for the format changed cell..
Question:
Is there a formula that I can place in a cell outside this column that will tell me if a cell within the column has this “Red, Accent 2, Lighter 40%” format,
and better yet, which row the non-consecutive cell is in?
A formula that constantly looks in the column would be better than VBA, but I can use all the help I can get.
Thank you.