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

One play ..
In say, F20:
=IF(D20<=E20,"a","r")
Format F20 with "Marlett" font
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Reen" wrote:
from conditional formula, how can i create a formula IF D20 <= E20, Then will
display tick. else will display, cross tick

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

Very good Max.

I had some event code worked out that did the same thing but the in-cell formula
is easier for OP.


Gord

On Sun, 26 Nov 2006 19:07:02 -0800, Max wrote:

One play ..
In say, F20:
=IF(D20<=E20,"a","r")
Format F20 with "Marlett" font

Thanks for compliments, Gord !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Very good Max.

I had some event code worked out that did the same thing but the in-cell
formula
is easier for OP.


Gord