if column E is not equal to Blank then user cant the Column F Blank & if Column E = "HO", then column G & H must have a numeric value btwn 1 -100 else user can left it blank
Thanks & regards Harish Upadhyay 9773284902 On 9/6/08, Ajay Varshney <[EMAIL PROTECTED]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
