Re: $$Excel-Macros$$ Conditional Formatting Excel 2007

[George Barrowcliff]

OK, please see attachment.

zp18

On Thu, Sep 8, 2011 at 2:22 PM, Venkat CV  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 
> *
> *
> *
>
> On Wed, Sep 7, 2011 at 1:30 PM, zp18  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

Re: $$Excel-Macros$$ Conditional Formatting Excel 2007

[Venkat CV]

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 *
*
*

On Wed, Sep 7, 2011 at 1:30 PM, zp18  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

[XLS S]

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  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

$$Excel-Macros$$ Conditional Formatting Excel 2007

[zp18]

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