Dear Tom,

Thanks for the help again, Well i am sorry i was unable to clearify to
you what exactly i was looking for. Well by Displaying i meant to
display through conditional formatting in a worksheet cell. I want this
query to be solved via normal worksheet formula, not through MACRO. I
am writing you the existing formula which i have, but i am unable to
add more conditions to it:

=IF(OR
(I20818;M20866;O20830;Q208240;S20890;U208800 );"FINE";IF(Y207="P";"PERFECT";IF(AND(AC207=1;AC2 07<=7);IF(AC207=-AD207;IF(X208<1;"BAD");"BAD");"BAD")))

This was my existing formula, if i were to add more conditions it wont
work. Please help me out. The conditions are around 10, and i have
already told you few of those, please help me out.


Regards,


Darno


---
Message posted from http://www.ExcelForum.com/