What is the problem? What do you actually want to know? There is a formula in column F : =IF(E17<>"","You Cant Left the Cell Blank","") this formula means if cell in column E is not blank then in the cell of column F it should show as "You Cant Left the Cell Blank" otherwise it should not show anything.
There is formula in column G: =IF(E17="HO","No must be entered between 1- 100","As u wish") this formula means if cell in column E is equal to "HO" then in the cell of column G it should show as "No must be entered between 1-100" otherwise it should show as "As u wish". In both columns IF formula has been used On 9/5/08, H Upadhyay <[EMAIL PROTECTED]> wrote: > Dear Exports, > > Need ur help > > I have 1 Excel file in which > > 1. you cant Left Column "F" Blank if Column "E" Not Blank > > 2. you cant Left Column "G" Blank if "E"= HO > > > Regards > Harish Upadhyay > ----------------------------- > 6th Flr, Solaris Building # 3, > Opp L & T Gate No - 6, > Saki Vihar Road, Powai > Andheri (E), Mumbai - 72 > D - +91 22 40754652 > C - +91 9773284902 > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
