Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What would I use for a formula to change the cell background color, if the
date entered in the cell is older then today's current date.

Thanks - George
 
Hi,

Go to Format -> Conditional Formatting.

Formula: =today()<A1

Regards,
A
 
Aristotle - I tryed your formula and it sort of works. As long as there is a
value in the cell and the date is older then todays date then the background
color kicks in. But if you clear the date entered in the field the background
color stays.

To add a little more detail to what I am doing - I have rows of dates - each
row of cells already has this conditional format:

=IF(COUNTIF(4:4,B4)>1,TRUE,FALSE)

Which detects any duplicate dates - which works great - just need something
to point expired dates.

Thanks - George
 
You must log in or register to reply here.

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

Excel Macro to automatically go to the right of the last colored cell 0
Comparison of columns using Conditional Formatting 3
Using Dates in Conditional Formatting 9
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Formula for Dates and CF Colour then convert to Text 3
IF OR AND in same conditional formula 2
Conditional Formatting Formula 1
Conditional formatting dates 3

Back
Top