Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another
Just copy the cell in which you have applied conditional formatting, after that select cells where you need to apply same formatting, then Paste special formatting to it by right clicking on selected cells. Check this attachment. Cheers!! On Sun, Jul 20, 2014 at 2:51 AM, Ahmed Emam wrote: > I applied the formula as you did to one cell, but now i want to apply it > to a whole table as attached. > I applied it to Cell C3 to be based on O, P, Q in the attached file. > Now i want to apply it to the cell range from C3 to N3 and C22 to N22. > > Brief: > > the formula to apply on every row from C to N Based on three other cells > in O,P & Q. > > > On Fri, Jul 18, 2014 at 2:30 PM, Vaibhav Joshi wrote: > >> Cheers. . >> On Jul 18, 2014 4:50 PM, "Ahmed Emam" wrote: >> >>> Thanks for your support >>> >>> >>> On Fri, Jul 18, 2014 at 9:40 AM, Vaibhav Joshi wrote: >>> Hi Check conditional format set in sheet.. First select Cell A1, then conditional formting and Manage Rules... Cheers!! On Fri, Jul 18, 2014 at 12:51 AM, Ahmed Emam wrote: > That' what i mean but i need t know how to do it because i will apply > it to other file > > thanks > > > On Thu, Jul 17, 2014 at 10:03 AM, Vaibhav Joshi wrote: > >> Check this!! >> >> Cheers! >> >> >> On Wed, Jul 16, 2014 at 8:47 PM, Ahmed Emam >> wrote: >> >>> I have an excel sheet and i want some cells to be highlighted by >>> some colors if other 3 cells filled by text. >>> please see the attached example: >>> >>> What i mean that Cell A to be highlighted Yellow if Cell A1 filled >>> by text >>> And to be highlighted Blue if Cell B1 filled by text >>> And to be highlighted Green if Cell C1 filled by text >>> >>> -- >>> 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 http://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 http://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 ti
Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another
Thanks On Sun, Jul 20, 2014 at 10:06 AM, Vaibhav Joshi wrote: > Just copy the cell in which you have applied conditional formatting, after > that select cells where you need to apply same formatting, then Paste > special formatting to it by right clicking on selected cells. > > Check this attachment. > > Cheers!! > > > On Sun, Jul 20, 2014 at 2:51 AM, Ahmed Emam wrote: > >> I applied the formula as you did to one cell, but now i want to apply it >> to a whole table as attached. >> I applied it to Cell C3 to be based on O, P, Q in the attached file. >> Now i want to apply it to the cell range from C3 to N3 and C22 to N22. >> >> Brief: >> >> the formula to apply on every row from C to N Based on three other cells >> in O,P & Q. >> >> >> On Fri, Jul 18, 2014 at 2:30 PM, Vaibhav Joshi wrote: >> >>> Cheers. . >>> On Jul 18, 2014 4:50 PM, "Ahmed Emam" wrote: >>> Thanks for your support On Fri, Jul 18, 2014 at 9:40 AM, Vaibhav Joshi wrote: > Hi > > Check conditional format set in sheet.. > > First select Cell A1, then conditional formting and Manage Rules... > > Cheers!! > > > > > On Fri, Jul 18, 2014 at 12:51 AM, Ahmed Emam > wrote: > >> That' what i mean but i need t know how to do it because i will apply >> it to other file >> >> thanks >> >> >> On Thu, Jul 17, 2014 at 10:03 AM, Vaibhav Joshi wrote: >> >>> Check this!! >>> >>> Cheers! >>> >>> >>> On Wed, Jul 16, 2014 at 8:47 PM, Ahmed Emam >>> wrote: >>> I have an excel sheet and i want some cells to be highlighted by some colors if other 3 cells filled by text. please see the attached example: What i mean that Cell A to be highlighted Yellow if Cell A1 filled by text And to be highlighted Blue if Cell B1 filled by text And to be highlighted Green if Cell C1 filled by text -- 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 http://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 http://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?
$$Excel-Macros$$ Need to run macro when outlook 2007 sent/receive or refresh or mail arrive in inbox
Dear expert, I have a macro Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) 'Private Sub Workbook_beforclose() 'Sub sendmail() '(mailid As String, nm As String, flname As String) Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) On Error Resume Next With OutMail .To = "lakshman...@gmail.com" .Subject = "Hello!" .Body = "Dear " & nm & "," & vbNewLine & vbNewLine & "HELLO !" & vbNewLine & vbNewLine & "Thank you" .Attachments.Add "c:\aaa.xlsb" .Send End With On Error GoTo 0 Set OutMail = Nothing Set OutApp = Nothing End Sub Need to run macro when outlook 2007 sent/receive or refresh or mail arrive in inbox Lakshman Prasad -- 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Need to run macro when outlook 2007 sent/receive or refresh or mail arrive in inbox
Dear expert, I have a macro Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) 'Private Sub Workbook_beforclose() 'Sub sendmail() '(mailid As String, nm As String, flname As String) Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) On Error Resume Next With OutMail .To = "lakshman...@gmail.com" .Subject = "Hello!" .Body = "Dear " & nm & "," & vbNewLine & vbNewLine & "HELLO !" & vbNewLine & vbNewLine & "Thank you" .Attachments.Add "c:\aaa.xlsb" .Send End With On Error GoTo 0 Set OutMail = Nothing Set OutApp = Nothing End Sub Need to run macro when outlook 2007 sent/receive or refresh or mail arrive in inbox Lakshman Prasad -- 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
Hi Vaibhav, Its Great buddy. Regards Ashish On 19 July 2014 22:02, Vaibhav Joshi wrote: > Check this.. > > Cheers!! > > > On Sat, Jul 19, 2014 at 2:32 PM, Vijay wrote: > >> Dear Team, >> >> >> Please Help on this to Solve this Problem !!! >> >> >> Regards, >> >> Vijayakumar R >> >> On Monday, July 14, 2014 3:46:45 PM UTC+5:30, Vijay wrote: >> >>> Dear Team, >>> >>> need your help to solve this problem !!! >>> >>> >>> 1) PFA, attached File already done by this Team, but require some more >>> query to be rectify >>> >>> >>> 2) This file Start Button having in ( Br ) Column, require once press >>> the start button, branch name based File should >>> >>> be Split only the same Branch like ( If i select Chennai means splited >>> file branch name should be available only >>> >>> Chennai branch pertains to data ) and file also attached based on the >>> Branch name pertains to Branch Email ID. >>> >>> 3) No need the start button to press the file, Run through only in Macro >>> and Splited file this start button wont >>> >>> appear. >>> >>> Thanks in Advance. >>> >>> Regard, >>> >>> Vijay >>> >>> >>> >> -- >> 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 http://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 http://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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Need to run macro when outlook 2007 sent/receive or refresh or mail arrive in inbox
Dear expert, I have a macro Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) 'Private Sub Workbook_beforclose() 'Sub sendmail() '(mailid As String, nm As String, flname As String) Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) On Error Resume Next With OutMail .To = "lakshman...@gmail.com" .Subject = "Hello!" .Body = "Dear " & nm & "," & vbNewLine & vbNewLine & "HELLO !" & vbNewLine & vbNewLine & "Thank you" .Attachments.Add "c:\aaa.xlsb" .Send End With On Error GoTo 0 Set OutMail = Nothing Set OutApp = Nothing End Sub Need to run macro when outlook 2007 sent/receive or refresh or mail arrive in inbox Lakshman Prasad -- 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Need some help with creating a macro
Basically i need a macro that does the following: i have a sheet in excel with items ( about 2815 items) each item has a 6 digit code. The sheet looks like this Row 1 : code Row 2: numeric info 1 digit Row 3: description for item Row 4: description for item Row 5: Price Now what i need is this: open new sheet and write a code ( for example 123456) and copy the line in the data sheet that matches this code. Can anyone help? Thank you 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 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.