ExcelBanter - Fill coloring for Past Dates in a worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Fill coloring for Past Dates in a worksheet (https://www.excelbanter.com/excel-worksheet-functions/180639-fill-coloring-past-dates-worksheet.html)

Jeffrey

Fill coloring for Past Dates in a worksheet

I want the worksheet to automatically turn a cell red when the date is past
due. Can some please help me with this?

JP[_4_]

Fill coloring for Past Dates in a worksheet

This link should be perfect for you:

http://www.mrexcel.com/tip054.shtml

HTH,
JP

"jeffrey" wrote:

I want the worksheet to automatically turn a cell red when the date is past
due. Can some please help me with this?

All times are GMT +1. The time now is 08:50 AM.