Conditional Formatting

G

Guest

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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting dates 3
Comparison of columns using Conditional Formatting 3
Conditional formatting referencing date of expiration 5
Conditional Formatting 3
vlookup formatting problem 1
Counting Colors of Cells set by Conditional Formatting 2
Excel conditional formatting with Weeknum 4
Conditional formatting on a dynamic range - workaround 1

Top