Is it possible to keep the conditional format of a cell permanent once the condition of the formula has been met? Once this condition is met in any cell, I would like the format(mine is a highlighting) to be premanent. Here is the formatting I am using. Appreciate any help. Thanks.
=SUBSTITUTE($M$1," ","" )= $P2 & Q$1