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 Mernalyn Irene 0
-50 $4.91 Julie Jocelyn Tiffany Ryan
Mark
$22.50 Grace Ronnie James Irene Mernalyn
$(0.78) Julie Tiffany Ryan Mark 0
$50.06 Grace James Mernalyn Irene 0
$2.65 Julie Tiffany Ryan Mark 0
$24.28 Grace 0 0 0
0
$(373.20) Julie Jocelyn Ryan 0
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
