Thread: Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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