nsaso.blogg.se

When the Conditional Formatting Rules Manager window appears, click on the "New Rule" button to enter the first condition.

Then in the Styles group, click on the Conditional Formatting drop-down and select Manage Rules. Select the Home tab in the toolbar at the top of the screen. 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 2010, is there a way to automatically highlight upcoming and past due dates?įor example, I have dates that certificates will expire in a spreadsheet.