Excel
 

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

Excel
 

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

Excel
 

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

Excel
 

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

Excel
 

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