Then select the color that you'd like to see the expired dates displayed in. When the Format Cells window appears, select the Patterns tab. Next, click on the Format button for Condition 2. What this formula means is that if the date in the cell is past today's date, then apply the formatting in Condition 2. Then enter the following formula that uses the NOW function: =NOW() In Condition 2, select "Cell Value Is" in the first drop down and "less than" in the second drop down. Next, click on the Add button to create a second condition. Since the formula uses relative referencing each value in column A will be evaluated individually. The value of A1 is put as the parameter in the ISBLANK function since this is the first value in the range of cells that you've selected. What this formula means is that if any cells in column A are blank, do not apply any formatting. Then enter the following formula that uses the ISBLANK function: =ISBLANK(A1)=TRUE When the Conditional Formatting window appears, select "Formula Is" in the drop down. Next, under the Format menu, select Conditional Formatting. In this example, we've selected all of column A since we don't know how many rows will have expiration date values. Is that possible?Īnswer: Yes, you can use conditional formatting to achieve exactly what you are looking for.įirst highlight the range of cells that you want to apply the formatting to. I would like Excel to highlight the ones that are 30 days from expiration in yellow and the ones that are past the expiration in red. Question: In Microsoft Excel 2003/XP/2000/97, is there a way to automatically highlight upcoming and past due dates?įor example, I have dates that certificates will expire in a spreadsheet.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |