Conditional Format "Specific Formula"

[rcb007]

I hope this is an easy one. I am trying to Highlight a Cell Border to RED, if a specific formula is used in the column.

I am not having any luck seeing how to do it. The formula I want to use is below, but I usually start at the top and drag it to the bottom.

=IFERROR(((INDEX($DC$20:$DC$910,MATCH($AK20,$A$20:$A$910,0)))),"")

The Format would be for Column X20 to X 220.

Thank

 

[Peter_SSs]

I'm not understanding. If you want to test for that formula and you have put it in the top cell and dragged it down, won't it be in every cell?
Can you clarify further?

 

[rcb007]

If I select a column, create a new conditional formatting by formula and paste the above formula. Can the cells that have that particular formula in it color the cell border even though there are not any values being shown? I hope that is more clear?

 

[Peter_SSs]

Can the cells that have that particular formula

That exact formula only?

If that formula was copied down the column, the next cell would have the formula below which is not exactly the same.
=IFERROR(((INDEX($DC$20:$DC$910,MATCH($AK21,$A$20:$A$910,0)))),"")

Would you want that second cell highlighted too?

 

[rcb007]

Yes you are correct I would want the AK20, AK21, AK22, etc.

 

[Peter_SSs]

Red borders do not show up well with the XL2BB tool so I have instead coloured the cell red if it contains a formula in that form. Hope that is what you want.

21 05 21.xlsm
	X
20
21
22
23
24
25	11
26
27
28	abcd
29
30
rcb007 1

Cell Formulas
Range	Formula
X20:X22,X29:X30,X24,X26:X27	X20	=IFERROR(((INDEX($DC$20:$DC$910,MATCH($AK20,$A$20:$A$910,0)))),"")
X25	X25	=5+6

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
X20:X220	Expression	=AND(LEFT(FORMULATEXT(X20),41)="=IFERROR(((INDEX($DC$20:$DC$910,MATCH($AK",RIGHT(FORMULATEXT(X20),23)=",$A$20:$A$910,0)))),"""")")	text	NO

 

[rcb007]

That is right on! Thank you so much! Yea, I do not think I would have figured that out... lol

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.