Expired Dates

thdan74 · #1 Dec 22, 2006, 08:37 AM

I have a training spreadsheet in excel. I would like to know how to highlight a date if the dates has expired one year from today's date. Is there a way to do that?

cajalat · Dec 22, 2006, 08:41 AM

You can use "Conditional Formatting" to highlight the cell based on a given condition. Conditional Formatting is found under the Format menu.

FirstKnight · Jan 30, 2007, 11:01 AM

Also make sure that the Condition 1 box says "Formula is" and you will need a "=" before the formula begins, so excel does not treat your formula as a string!



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!