Posted to microsoft.public.excel.newusers
|
|
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
|