Forum Discussion
Solved
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 ...
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.
This should work!
AND I admit I am not very fluent with excel.
I have attached the file in question.
Ideally, I would be able to assign a color to the total from the high, medium and low priority cells, and excel would magically fill in the background colors of all cells included in the range of the formula.
- It works, thank you!!
I can't figure out how to duplicate to other cells. Any advice or tutorials?You just need to select the cells you want to apply the formatting
On Applies to you change the range you want to apply
- Perfect, thank you.