conditional formatting a date

  • Thread starter Thread starter Neilvass
  • Start date Start date
N

Neilvass

How do i make a cell change colour
a) if the date entered in it has passed
B) if it is before that date
 
How do i make a cell change colour
a) if the date entered in it has passed
Click to expand...

Select the range, eg select A2:A10 (A2 active),
then apply CF using Formula Is:
=AND(A2<TODAY(),A2<>"")
Format to taste > OK

The additional check: A2<>""
is to prevent blank cells (if any) from spuriously triggering the CF
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
 
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

Conditional formatting in Excel 2010 2
Conditional format for date 4
Using CF to change colour in cell based on date? 4
Can you conditionally format a whole row based on data in one cel 1
Date Calculation & Conditional Formatting 3
Excel Import Comments 3
Conditional Formatting Dates 5
conditional formmating - formulas 1

Back
Top