Dear Experts,
Please help me in highting number which is greater than 2 by excel vba in
red colour.
from B2: F12 range.
Thanks
Regards,
Chaya
--
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 @
Dear Experts,
Please help me in highlight number which is greater than 2 by excel vba in
red colour.
from B2: F12 range.
Please find the attachment.
Small changes, in Attached file in M2 cell, whatever the value i will put
the same value greater than its value should highlight it.
Example :
Here.
On Wed, May 8, 2013 at 11:33 AM, Chaya chayamon...@gmail.com wrote:
Dear Experts,
Please help me in highting number which is greater than 2 by excel vba in
red colour.
from B2: F12 range.
Thanks
Regards,
Chaya
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
Updated as per revised requirement.
On Wed, May 8, 2013 at 12:04 PM, Chaya chayamon...@gmail.com wrote:
Dear Experts,
Please help me in highlight number which is greater than 2 by excel vba
in red colour.
from B2: F12 range.
Please find the attachment.
Small changes, in Attached file
On Wed, May 8, 2013 at 11:33 AM, Chaya chayamon...@gmail.com wrote:
Dear Experts,
Please help me in highting number which is greater than 2 by excel vba in
red colour.
from B2: F12 range.
Thanks
Regards,
Chaya
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
try this
Sub Highlighting_cell()
Dim rngCell As Range
Dim rngRange As Range
Set rngRange = Intersect(Sheet1.Range(a1).CurrentRegion,
Sheet1.Range(a1).CurrentRegion.Offset(1, 1))
For Each rngCell In rngRange
If rngCell.Value 2 Then
rngCell.Font.Color =
Thank you very very much Abhishek Sir And Priti mam.
Once again thank you very much for the solution.
Regards,
Chaya
Regards,
Chaya
On Wed, May 8, 2013 at 12:12 PM, priti verma pritiverma1...@gmail.comwrote:
try this
Sub Highlighting_cell()
Dim rngCell As Range
Dim
Abhishek sir,
The second solution provided to me is fine but-
firstly - if i put 2 then all the number greater than 2 will mark as red,
again while putting 5 than it will also mark as red as well 2 also,
generally only 5 should be mark as red not 2 while putting 5 in M2 cells.
Hope you
Updated attached.
On Wed, May 8, 2013 at 12:33 PM, Chaya chayamon...@gmail.com wrote:
Abhishek sir,
The second solution provided to me is fine but-
firstly - if i put 2 then all the number greater than 2 will mark as red,
again while putting 5 than it will also mark as red as well 2
Exactly Priti you are right but your formula is not working ... as i
observe that you are just want increase your post count ..
in we will provide top best solution not a temporary solution
I totally agree with sunny...
On Wed, May 8, 2013 at 11:26 AM, priti verma
Thanks for your suggestion, i know what i need to do ..
On Wed, May 8, 2013 at 5:05 PM, Sant Ram santram...@gmail.com wrote:
Exactly Priti you are right but your formula is not working ... as i
observe that you are just want increase your post count ..
in this group we will try to
Dear Sant Ram,
You may note that in the original query there was nothing related to the
sorting and I tried to apply a different and simple approach which works
without the sorting so the solution is not inoperable and if the data is
not sorted, it is not temporary also. You can find problems
and one more thing best solutions with no acknowledgement whatsoever
On Wed, May 8, 2013 at 5:46 PM, priti verma pritiverma1...@gmail.comwrote:
Dear Sant Ram,
You may note that in the original query there was nothing related to the
sorting and I tried to apply a different and simple
Dear Anil sir, I have seen attachment file, Thanx for responce me. but it's not
my solution. My problem is if database sheet's cell text are links with
hyperlink, that same hyperlink should access from home sheet. (Give the code
about hyperlinks)Awaiting your reply .
Sajid
Date: Tue, 7 May
Dear Experts
I have a query where the sheets have a huge number of merged
cells. Now i want to remove all the merged cell and transform into its
corresponding names for entire active sheets.
Can it be done with formula or macros.
Please find the attachment, i have
Here.
On Wed, May 8, 2013 at 6:23 PM, Chaya chayamon...@gmail.com wrote:
Dear Experts
I have a query where the sheets have a huge number of merged
cells. Now i want to remove all the merged cell and transform into its
corresponding names for entire active sheets.
Can
Hi Experts,
I have a query, if sheet name is similar, how can create a hyperlink. query
is attached.
I want to via VBA.
Regards,
Kuldeep
--
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 @
=HYPERLINK(#'A2'!a1,Click Here to Visit A2)
On Wed, May 8, 2013 at 7:37 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi Experts,
I have a query, if sheet name is similar, how can create a hyperlink.
query is attached.
I want to via VBA.
Regards,
Kuldeep
--
Are you =EXP(E:RT) or
Priti, You are absolutely right. It is up to the person who raised the
query to test sugestested solutions and respond. If it is not working to
say in what respect it is not working, If it is working to acknowledge
that.
Regards
David Grugeon
On 8 May 2013 22:16, priti verma
Hi Experts,
I'm trying to upload a file from shared folder (directory) to the internet
explorer.
Need a VBA code to do this. Could anyone help me on this?
Thanks in advance.
--
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
Dear Sajid,
Pl Elaborate more on this. didn't understood. Pl give eg. in the
attachment.
Warm Regards,
Gawli Anil
On Wed, May 8, 2013 at 6:23 PM, SAJID MEMON sajidwi...@hotmail.com wrote:
Dear Anil sir,
I have seen attachment file, Thanx for responce me. but it's not my
solution. My
Dear Abhishekji,
Can you provide the code with comments ...
On Wed, May 8, 2013 at 6:57 PM, Abhishek Jain abhishek@gmail.comwrote:
Here.
On Wed, May 8, 2013 at 6:23 PM, Chaya chayamon...@gmail.com wrote:
Dear Experts
I have a query where the sheets have a huge number of
Dear Abhishek,
Sorry for the late reply.
Yes, the solution provided to me its perfectly working. thank you.
Regards,
Chaya
On Wed, May 8, 2013 at 6:57 PM, Abhishek Jain abhishek@gmail.comwrote:
Here.
On Wed, May 8, 2013 at 6:23 PM, Chaya chayamon...@gmail.com wrote:
Dear Kuldeep,
Pl find attachment.
Warm Regards,
Gawli Anil.
On Wed, May 8, 2013 at 7:37 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi Experts,
I have a query, if sheet name is similar, how can create a hyperlink.
query is attached.
I want to via VBA.
Regards,
Kuldeep
--
You
Dear Manthan,
Pls Elaborate More with Eg.
Warm Regards,
Gawli Anil
On Thu, May 9, 2013 at 2:26 AM, Mathan mathan4s...@gmail.com wrote:
Hi Experts,
I'm trying to upload a file from shared folder (directory) to the internet
explorer.
Need a VBA code to do this. Could anyone help me on
IN particular we need to know what type of file is it that you want to
Upload. Is it an internet file like .html, .asp .php etc or is it an
excel XLS file, xlsm, xlsb, etc. or perhaps a different type.
Then we need to know if there is an internet server running on the site
where the file is
26 matches
Mail list logo