Forum Discussion
Solved
How to have a cell follow a formula ONLY if the cell it's mapping to is a certain colour?
I'm not sure if it's possible and I don't have a screen shot (I'm on a computer that doesn't have excel atm) but I'll try my best to explain: I have a formula in A1: =B2 However, I only wan...
Yeah you can do it but you need to be tricky for this
First read this article https://excelsirji.com/vba-code-to-count-cells-by-color/
Use second code given on this link and then use if formula
Put the Yellow color on A2 (or anywhere just change the reference in below formula then) cell and enter this formula in A1
=if(CountByColor(B2,A2)>0,B2,0)
Yeah you can do it but you need to be tricky for this
First read this article https://excelsirji.com/vba-code-to-count-cells-by-color/
Use second code given on this link and then use if formula
Put the Yellow color on A2 (or anywhere just change the reference in below formula then) cell and enter this formula in A1
=if(CountByColor(B2,A2)>0,B2,0)
