Excel 7 I have 60 rows, one for each of two shifts, each day of the month Each row has 7 columns with an employee name in each column I have one column (M) with the number of hours worked.
I have a constant field named "Associate" which contains the name of one of the employees Currently I have conditional formatting the will highlight the employee whose name is contained in the "Associate" cell and it the rule looks like this: Cell value = Associate Format[black, yellow background] Applies to =$N$30:$T$89 I want to add in the condition of the hours worked column (M) less than 4.5 in order for the format to be true. How can I add this condition? I tried: =AND($N30:$T30=Associate,$M30<MinHrs) Thanks, zp18 -- ---------------------------------------------------------------------------------- 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