We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Date Time 12/12/2011 9:06:45 12/12/2011 9:06:45 12/11/2011 10:49:10 12/13/2011 10:54:21 12/14/2011 23:46:10 12/15/2011 12:10:55 12/16/2011 12:13:38 12/17/2011 12:22:13 12/18/2011 13:07:47 12/1/2011 19:25:50
Cells.FormatConditions.Delete Columns("A:A").Select Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _ "=WEEKDAY(A2,2)>5" Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority With Selection.FormatConditions(1).Interior .PatternColorIndex = xlAutomatic .ThemeColor = xlThemeColorAccent6 .TintAndShade = 0 End With Selection.FormatConditions(1).StopIfTrue = False
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Transfer Worksheet Data to Userform & Calculate based on Sum Range||28||43|
|Email Excel WB by selecting name from a dropdown list to Outlook.||5||43|
|excel file icon - over last few months weird||2||25|
|Linking Cells within workbooks - how to mass re-direct to a different sheet within a workbook||5||13|
Join the community of 500,000 technology professionals and ask your questions.