Identifying cells that have '+1' at the end of the formula

[Red over White]

I have a column which predominantly has the formula "=INDIRECT("A"&ROW()-1)+1". There are a small number of cells that don't have this formula, and I want to identify, using conditional formatting, those cells that don't end +1. However, I have been unable to come up with anything that works.

Any suggestions, TIA

 

[dreid1011]

See if this works:

Book1
	B
2	1
3	1
4	1
5	0
6	1
7	1
8	1
9	0
10	1
11	1
12	1
13	0
14	1
15	1
16	1
17	1
18	1
19	1
20	1
Sheet1

Cell Formulas
Range	Formula
B2:B4,B6:B8,B10:B12,B14:B20	B2	=INDIRECT("A"&ROW()-1)+1
B5,B9,B13	B5	=INDIRECT("A"&ROW()-1)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B20	Expression	=RIGHT(FORMULATEXT(B2),2)<>"+1"	text	NO

 

[Red over White]

See if this works:

Book1
	B
2	1
3	1
4	1
5	0
6	1
7	1
8	1
9	0
10	1
11	1
12	1
13	0
14	1
15	1
16	1
17	1
18	1
19	1
20	1
Sheet1

Cell Formulas
Range	Formula
B2:B4,B6:B8,B10:B12,B14:B20	B2	=INDIRECT("A"&ROW()-1)+1
B5,B9,B13	B5	=INDIRECT("A"&ROW()-1)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B20	Expression	=RIGHT(FORMULATEXT(B2),2)<>"+1"	text	NO

It works, thanks!

 

[dreid1011]

You're welcome, and happy to help.

 

[Joe4]

Red over White,

Please Note: In the future, when marking a post as the solution, please mark the post that contains the solution (not your own post acknowledging that some other post was the solution).
When a post is marked as the solution, it is then shown right underneath the original question so people viewing the question can easily see the question and solution in a single quick glance without having to hunt through all the posts.

I have updated this thread for you.