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 & "=" & MonthName(Month(StartDate), True) & _
"+" & Day(StartDate) & "+" & Year(StartDate) & _
"=" & MonthName(Month(EndDate), True) & _
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
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
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
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