You cannot do this using CF.

You would have to go to event code in my opinion.


Gord Dibben MS Excel MVP

On Sun, 26 Nov 2006 18:59:01 -0800, Reen wrote:

from conditional formula, how can i create a formula IF D20 <= E20, Then will
display tick. else will display, cross tick