I want to display a formula in a cell only if another cell equals a specific word, and if that cell does not equal that word I don't want the formula to be in action. This is because when the cell is not displaying that word, the cell that the formula is written in has been conditionally formatted to change.
Solved by K. U. in 18 mins