I have a column of dates which are entered by our sales guys when they last had contact with a customer. I wish to highlight the row based on the date they enter being over 60 days ago. All the forums i have looked at have showed me how to do it based on todays date, but in this circumstance todays date is irrelevant. Help please!
- Hot
- Active
-
Forum Thread: How to Make a Simple Report Card Template in Excel 0 Replies
6 yrs ago -
Forum Thread: How to Insert 'NESTED if' with Ease 0 Replies
6 yrs ago -
Forum Thread: How to Memorise the Excel Formula Syntax 0 Replies
6 yrs ago -
Forum Thread: How to Remove Line Breaks in Excel 0 Replies
6 yrs ago -
Forum Thread: How to Create a Speedometer Chart or Gauge Chart in Excel 0 Replies
6 yrs ago -
Forum Thread: How to Add Dependent Data Validations in Excel 0 Replies
6 yrs ago -
Forum Thread: How to Create a Task Tracker in Excel 0 Replies
6 yrs ago -
Forum Thread: OneNote 2010 document 0 Replies
8 yrs ago -
Forum Thread: How to Turn Off Panning Hand 0 Replies
8 yrs ago -
Forum Thread: While in a Spread Sheet, I Click on One Cell and It Will Auto Highlight Many. Why and How Do I Undo It? 0 Replies
8 yrs ago -
Mail Merge Software: Hello. 0 Replies
8 yrs ago -
Forum Thread: PPTX File Is Giving an Error and Can't Be Opened. 2 Replies
8 yrs ago -
Forum Thread: How to Use Vlookup 0 Replies
8 yrs ago -
Forum Thread: Need Some Help with an Inventory Formula. (Purchase Date)(Sold Date)(Number of Days Held). However, if the Inventory Is 0 Replies
8 yrs ago -
Forum Thread: How to use AND, OR with the IF function 1 Replies
8 yrs ago -
Forum Thread: How to Create a Personal Finance Spreadsheet 0 Replies
8 yrs ago -
Forum Thread: How to Format a Chart Based on Another Chart Format 0 Replies
8 yrs ago -
Forum Thread: Powerpoint Presentation Design 0 Replies
8 yrs ago -
Forum Thread: How to Create Excel Based Interactive Awesome Histograms 0 Replies
8 yrs ago -
Forum Thread: Why Aren't TRUE Excel Based Dashboards More Prevalent? 0 Replies
8 yrs ago
-
How To: Generate random numbers (with decimals) in Excel
-
How To: Create a Basic Attendance Sheet in Excel
-
How To: Create a Tangent Line with Excel
-
How To: Make a footnote in MS Word 2007
-
How To: Conditionally format at every change in value in Excel
-
How To: Find a P-Value with Excel
-
How To: Multiply column times row with Transpose in MS Excel
-
How To: Do matrix multiplication and inverse in MS Excel
-
How To: Compare two lists and extract the new values in Excel
-
How To: Force text formulas to wrap with Excel's CHAR function
-
How To: Clear data & cell contents in Excel using a macro
-
How To: Generate a dynamic list from a table in MS Excel
-
How To: Change Excel options directly in the Registry
-
How To: Retrieve the name of a lowest-bidding vendor in Excel
-
How To: Create an Excel table in Excel 2007
-
How To: Group duplicates & extract unique records in MS Excel
-
How To: Create a dynamic weekly chart in Microsoft Excel
-
How To: Use VLOOKUP across worksheets in MS Excel 2007
-
How To: Freeze titles and create split screens in Microsoft Excel 2010
-
How To: Disable quick fill handle & drag-drop Excel features
2 Responses
Check out this site:
http://www.contextures.com/xlCondFormat03.html#Expiry
I used conditional formatting to highlight a cell (make it red) if the date is next month.
Select the cells you wanted the formula to apply to (in my case, column B)
Select Conditional Formatting
Select New rule
Select Format only cells that contain
Select dates occurring (under the cell value pull down menu)
Select next month (I wanted some advance warning when the expiration date was coming up)
Select Format to apply font and/or fill formatting you want to apply to the cells
Hope this helped.
Conditional formatting has been a feature in Excel for years, but in Excel 2013 there's a faster way for you to to visualise patterns.
Save time by selecting your data, a small box will appear with a lightning bolt symbol. Click on this to get the conditional format options. Find out more @
http://www.microsofttraining.net/b/blog/tag/conditional-formatting/
Share Your Thoughts