I would like to be able to enter a number into a cell and then have that
number automatically change to a different number. Example: I would like to
be able to enter 1000 in cell A2 and then have $15.09 be visible instead. Is
this possible? I have tried using =IF(A2<1500,15.09,"") in the Formula Is
option of the Conditional Formatting option, however, it does not work.
Please advice. Thanks.