Re: $$Excel-Macros$$ Conditional Formatting Excel 2007
Hi , See Below Links... http://www.contextures.com/xlcondformat03.html\ http://www.dummies.com/how-to/content/applying-conditional-formatting-in-excel-2007.html *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* * * On Wed, Sep 7, 2011 at 1:30 PM, zp18 irvinep...@gmail.com wrote: A1=the name of an employee, defined name is Suspect A2= an amount of money, defined as MaxLoss B1:B8 is a column of money defined as Shortages C1:G8 is a range of employee names defined as Associates if the money contained in MaxLoss is less than the amount in column of Shortages and the Suspect's name is contained in the Associates range then do something(bold, red, flashing etc) The intent is to match an employees name to shortages using conditional formatting James$57.20 Grace Ronnie MernalynIrene 0 -50 $4.91 Julie Jocelyn Tiffany RyanMark $22.50 Grace Ronnie James Irene Mernalyn $(0.78)Julie Tiffany RyanMark 0 $50.06 Grace James MernalynIrene 0 $2.65 Julie Tiffany RyanMark0 $24.28 Grace 0 00 0 $(373.20) Julie Jocelyn Ryan0 0 What should the statement be? I cannot get the hang of logical operators in conditional formatting, any help would be appreciated. TIA -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Conditional Formatting Excel 2007
OK, please see attachment. zp18 On Thu, Sep 8, 2011 at 2:22 PM, Venkat CV venkat1@gmail.com wrote: Hi , See Below Links... http://www.contextures.com/xlcondformat03.html\ http://www.dummies.com/how-to/content/applying-conditional-formatting-in-excel-2007.html *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71 * * * On Wed, Sep 7, 2011 at 1:30 PM, zp18 irvinep...@gmail.com wrote: A1=the name of an employee, defined name is Suspect A2= an amount of money, defined as MaxLoss B1:B8 is a column of money defined as Shortages C1:G8 is a range of employee names defined as Associates if the money contained in MaxLoss is less than the amount in column of Shortages and the Suspect's name is contained in the Associates range then do something(bold, red, flashing etc) The intent is to match an employees name to shortages using conditional formatting James$57.20 Grace Ronnie MernalynIrene 0 -50 $4.91 Julie Jocelyn Tiffany RyanMark $22.50 Grace Ronnie James Irene Mernalyn $(0.78)Julie Tiffany Ryan Mark0 $50.06 Grace James MernalynIrene 0 $2.65 Julie Tiffany RyanMark0 $24.28 Grace 0 00 0 $(373.20) Julie Jocelyn Ryan0 0 What should the statement be? I cannot get the hang of logical operators in conditional formatting, any help would be appreciated. TIA -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- George W -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel ConditionalFormatting.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Conditional Formatting Excel 2007
A1=the name of an employee, defined name is Suspect A2= an amount of money, defined as MaxLoss B1:B8 is a column of money defined as Shortages C1:G8 is a range of employee names defined as Associates if the money contained in MaxLoss is less than the amount in column of Shortages and the Suspect's name is contained in the Associates range then do something(bold, red, flashing etc) The intent is to match an employees name to shortages using conditional formatting James$57.20 Grace Ronnie MernalynIrene 0 -50 $4.91 Julie Jocelyn Tiffany Ryan Mark $22.50 Grace Ronnie James Irene Mernalyn $(0.78)Julie Tiffany RyanMark0 $50.06 Grace James MernalynIrene 0 $2.65 Julie Tiffany RyanMark0 $24.28 Grace 0 00 0 $(373.20) Julie Jocelyn Ryan0 0 What should the statement be? I cannot get the hang of logical operators in conditional formatting, any help would be appreciated. TIA -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Conditional Formatting Excel 2007
Hey , Please send the attachment... try the below link http://www.contextures.com/xlcondformat02.html http://www.wikihow.com/Apply-Conditional-Formatting-in-Excel On Wed, Sep 7, 2011 at 1:30 PM, zp18 irvinep...@gmail.com wrote: A1=the name of an employee, defined name is Suspect A2= an amount of money, defined as MaxLoss B1:B8 is a column of money defined as Shortages C1:G8 is a range of employee names defined as Associates if the money contained in MaxLoss is less than the amount in column of Shortages and the Suspect's name is contained in the Associates range then do something(bold, red, flashing etc) The intent is to match an employees name to shortages using conditional formatting James$57.20 Grace Ronnie MernalynIrene 0 -50 $4.91 Julie Jocelyn Tiffany RyanMark $22.50 Grace Ronnie James Irene Mernalyn $(0.78)Julie Tiffany RyanMark 0 $50.06 Grace James MernalynIrene 0 $2.65 Julie Tiffany RyanMark0 $24.28 Grace 0 00 0 $(373.20) Julie Jocelyn Ryan0 0 What should the statement be? I cannot get the hang of logical operators in conditional formatting, any help would be appreciated. TIA -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel