Forum Discussion
Fill background color of cell 1 if cell 1 is included in cell 2 formula
I am trying to add a fill color to cell 1 if cell 1 is included in the formula of a cell 2.
Also, it would need to remove fill color from cell 1 if it is removed from cell 2.
I have attached an example.
Is this doable?
I need to admit that it is the first time I see something like that.
Well, the conditional formatting formula would be something like that.
=FIND(SUBSTITUTE(ADDRESS(ROW(),COLUMN()),"$",""),FORMULATEXT($B15))>0Remember to change the reference where the "main" formula is. This case the formula is on B15
Find attachment.
12 Replies
I'm confused when you say "included in the formula ..." you mean the value as a result of the formula or the range (AC75) on the formula itself?
Juliano-Petrukio The range of the formula.
I need to admit that it is the first time I see something like that.
Well, the conditional formatting formula would be something like that.
=FIND(SUBSTITUTE(ADDRESS(ROW(),COLUMN()),"$",""),FORMULATEXT($B15))>0Remember to change the reference where the "main" formula is. This case the formula is on B15
Find attachment.
