i would like to have a merged cell display message "X" when the different
cell value is exceeded. I have tried conditional formatting and still the
merged cell displays nothing.
Formula
if(a15<0.02,"Enter new text",""). Pattern of yellow and font of red chosen.

No results when entered. please advise if above forumula is correct.