In Excel I have 2 columns with dates in them. D1:D20 Start Date G1:G20 End Date. I want to highlight the cell in the range G1:G20 if the date is more than 14 days form the date in D1:D20. Obvious answer is conditional formatting, but I can't seem to create a formula with relative cell references. [more inside]
Can you help me construct a slightly complex Pivot Table in Excel? [more inside]
I have an Excel pivot table for sales performance data. I want to break that down for regional managers so that they only have access to their own offices' data while preserving the nice formatting that the pivot table provides. Is there an easy way to do that? [more inside]
Excel Question - Is there a way in Excel to evaluate whether a cell contains text that is in all caps as opposed to proper (first letter) caps. I know I can force cells into Upper or Proper, but I don't want to do that, i just want to flag and sort them.