ExcelBanter - Conditional Formatting

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

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

- - Conditional Formatting (https://www.excelbanter.com/excel-worksheet-functions/37427-conditional-formatting.html)

George

Conditional Formatting

In my spread sheet there are row of dates. How can I just conditional
formatting to have the background color of each cell change when the date is
older then today's date.

Thanks

JE McGimpsey

One way:

Select your cells. Assume A1 is active. Choose Format/Conditional
Formatting...

CF1: =A1<TODAY()
Format1: Patterns/<desired color

In article ,
George wrote:

In my spread sheet there are row of dates. How can I just conditional
formatting to have the background color of each cell change when the date is
older then today's date.

All times are GMT +1. The time now is 07:19 AM.