Re: $$Excel-Macros$$ UDF Function for conditoin formetting

2011-08-18 Thread kurikkal padinjarappalla
y u r asking to send mail personally to u. On Tue, Aug 16, 2011 at 7:31 PM, Excel VBASQL wrote: > I can do this email me at excelvba...@gmail.com > > > On Tue, Aug 16, 2011 at 11:02 AM, ICWAI Help wrote: > >> Please provide me UDF functino for below requirement >> >> example:) >> >> if the cell

Re: $$Excel-Macros$$ UDF Function for conditoin formetting

2011-08-17 Thread dguillett1
CWAI Help Sent: Tuesday, August 16, 2011 4:04 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ UDF Function for conditoin formetting Please find the attached file and give me the solution :) if the perticuler cell value is 4 then next 4 coloumn cells in same row shoudl be highl

RE: $$Excel-Macros$$ UDF Function for conditoin formetting

2011-08-17 Thread Rajan_Verma
17, 2011 2:34 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ UDF Function for conditoin formetting Please find the attached file and give me the solution :) if the perticuler cell value is 4 then next 4 coloumn cells in same row shoudl be highleted . On Tue, Aug 16, 2011 at

Re: $$Excel-Macros$$ UDF Function for conditoin formetting

2011-08-16 Thread Muhtasim Billah
On 8/16/11, Excel VBASQL wrote: > I can do this email me at excelvba...@gmail.com > > On Tue, Aug 16, 2011 at 11:02 AM, ICWAI Help wrote: > >> Please provide me UDF functino for below requirement >> >> example:) >> >> if the cell value is 4 then including active cell next 4 cell in a row >> should

Re: $$Excel-Macros$$ UDF Function for conditoin formetting

2011-08-16 Thread ICWAI Help
Please find the attached file and give me the solution :) if the perticuler cell value is 4 then next 4 coloumn cells in same row shoudl be highleted . On Tue, Aug 16, 2011 at 11:42 PM, dguillett1 wrote: > I did this VERY recently in another formum. Was it you? > Right click sheet tab>view cod

Re: $$Excel-Macros$$ UDF Function for conditoin formetting

2011-08-16 Thread dguillett1
I did this VERY recently in another formum. Was it you? Right click sheet tab>view code>insert this Private Sub Worksheet_Change(ByVal Target As Range) Dim tr As Long tr = Target.Row Rows(tr).Borders(xlEdgeBottom).LineStyle = xlNone If Target.Column <> 1 Or Not IsNumeric(Target) Or _ Len(Applicati

Re: $$Excel-Macros$$ UDF Function for conditoin formetting

2011-08-16 Thread Excel VBASQL
I can do this email me at excelvba...@gmail.com On Tue, Aug 16, 2011 at 11:02 AM, ICWAI Help wrote: > Please provide me UDF functino for below requirement > > example:) > > if the cell value is 4 then including active cell next 4 cell in a row > should be higleted with color. > ex > if > a1 is 4