I am trying to use conditional formulas on the answers to a formula. However, if I apply the conditional format rule to a cell, it seems to reference the formula itself and not the answer to the formula. For example, if I type '160%' into the cell, the conditional formatting works, but if I put in a formula that has the result ''160%', the conditional formatting does not work.
Solved by T. H. in 22 mins