Conditional Formatting

G

George

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
 
J

JE McGimpsey

One way:

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

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