Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 2 topics
These are examples of using several line breaks. I hope they will help:
1)
qurl = "http://finance.google.com/finance/historical?q="; & Sym
qurl = qurl & "&startdate=" & MonthName(Month(StartDate), True) & _
"+" & Day(StartDate) & "+" & Year(StartDate) & _
"&enddate=" & MonthName(Month(EndDate), True) & _
"+" & Day(EndDate) & "+" & Year(EndDate) & "&output=csv"
2nd Example)
MessageLBC = "Special Fibonacci lookback averages choice." _
& Chr(10) & "5, 13 and 21 day averages - Choose 'OK'" _
& Chr(10) & "OR" _
& Chr(10) & "choose 'Cancel' " _
& Chr(10) & "to choose lookback, which doubles from first entry, like
8,16 and 32"
3rd Example:
Set QT = ActiveSheet.QueryTables.Add( _
Connection:="URL;" & Thisurl, _
Destination:=Range("A1"))
On Wed, Mar 7, 2018 at 3:25 PM, wrote:
> excel-macros@googlegroups.com
>
> Google
> Groups
>
>
> Topic digest
> View all topics
>
>
>- Conditional formatting issue <#m_-4074006883849396307_group_thread_0>
>- 3 Updates
>- Trouble with VBA line break <#m_-4074006883849396307_group_thread_1>
>- 1 Update
>
> Conditional formatting issue
>
> vikas khen : Mar 07 05:08PM +0530
>
> Hi All,
>
> Request all of you to kindly help me on the attached sheet.
>
>
> I need conditional formatting for based on following two conditions
>
> 1) If the Actual date is less than or equal to Projected date it should
> highlighted in Green color
>
> and
> 2) If the Actual date is Greater than Projected date it should highlighted
> in Red Color
>
> Yor help in this regards will be highly appreciated.
>
> Thanks
> sourav devrani : Mar 07 08:05PM +0530
>
> PFA
>
> vikas khen : Mar 07 08:13PM +0530
>
> Thanks Sourav for your help.
>
> On Wed, Mar 7, 2018 at 8:05 PM, sourav devrani <
> souravdevrani1...@gmail.com>
> wrote:
>
> Back to top <#m_-4074006883849396307_digest_top>
> Trouble with VBA line break
>
> Priti_Verma : Mar 07 02:04AM -0800
>
> try this
> Range("T2").FormulaR1C1 =
> "=COUNTIF(RC17,""<94"")+COUNTIF(RC18,""<89"")+COUNTIF(RC19,""<90"")" _
> &
> "+COUNTIF(RC12,"">3.46"")+COUNTIF(RC13,"">2.82"")+COUNTIF(RC14,"">2.44"")+
> COUNTIF(RC15,"">2.31"")+COUNTIF(RC16,"">2.67"")"
>
>
> On Friday, March 2, 2018 at 10:07:27 PM UTC+5:30, Johnny wrote:
> Back to top <#m_-4074006883849396307_digest_top>
> You received this digest because you're subscribed to updates for this
> group. You can change your settings on the group membership page
>
> .
> To unsubscribe from this group and stop receiving emails from it send an
> email to excel-macros+unsubscr...@googlegroups.com.
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Conditional formatting issue
Thanks Sourav for your help. On Wed, Mar 7, 2018 at 8:05 PM, sourav devrani wrote: > PFA > > On Wed, Mar 7, 2018 at 5:08 PM, vikas khen wrote: > >> Hi All, >> >> Request all of you to kindly help me on the attached sheet. >> >> >> I need conditional formatting for based on following two conditions >> >> 1) If the Actual date is less than or equal to Projected date it should >> highlighted in Green color >> >> and >> 2) If the Actual date is Greater than Projected date it should >> highlighted in Red Color >> >> Yor help in this regards will be highly appreciated. >> >> Thanks >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at https://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Conditional formatting issue
PFA On Wed, Mar 7, 2018 at 5:08 PM, vikas khen wrote: > Hi All, > > Request all of you to kindly help me on the attached sheet. > > > I need conditional formatting for based on following two conditions > > 1) If the Actual date is less than or equal to Projected date it should > highlighted in Green color > > and > 2) If the Actual date is Greater than Projected date it should highlighted > in Red Color > > Yor help in this regards will be highly appreciated. > > Thanks > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Conditional formating.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Conditional formatting issue
Hi All, Request all of you to kindly help me on the attached sheet. I need conditional formatting for based on following two conditions 1) If the Actual date is less than or equal to Projected date it should highlighted in Green color and 2) If the Actual date is Greater than Projected date it should highlighted in Red Color Yor help in this regards will be highly appreciated. Thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Conditional formating.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Re: Trouble with VBA line break
try this
Range("T2").FormulaR1C1 =
"=COUNTIF(RC17,""<94"")+COUNTIF(RC18,""<89"")+COUNTIF(RC19,""<90"")" _
&
"+COUNTIF(RC12,"">3.46"")+COUNTIF(RC13,"">2.82"")+COUNTIF(RC14,"">2.44"")+COUNTIF(RC15,"">2.31"")+COUNTIF(RC16,"">2.67"")"
On Friday, March 2, 2018 at 10:07:27 PM UTC+5:30, Johnny wrote:
>
> I'm having trouble breaking this line in VBA.
>
> Range("T2").FormulaR1C1 =
> "=COUNTIF(RC17,""<94"")+COUNTIF(RC18,""<89"")+COUNTIF(RC19,""<90"") _
>
> +COUNTIF(RC12,"">3.46"")+COUNTIF(RC13,"">2.82"")+COUNTIF(RC14,"">2.44"")+COUNTIF(RC15,"">2.31"")+COUNTIF(RC16,"">2.67"")"
>
> I put the space and underscore after that parenthesis, and I tried
> breaking it after the "+" sign
>
> I'm wondering if the problem is the type of statement I'm writing? Any
> help would be much appreciated
>
> John
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
