• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional formatting when any date is in cell

D

Deedee

New Member
Hello there,


I'm working on a spreadsheet in Excel 2010 for making a note of training courses that people have attended and which ones are mandatory.


So far if I've put in conditional formatting so any cell with M in goes red to show it must be attended.


I want to make the cell go green (or whatever colour) if there is a date in the cell- so have tried =B3<TODAY()

which is great but also turns the cell green when the cell is blank.


I would like to only turn the cell green if there is a date entered in the cell, all training dates should be in the past as they are only entered once attended.


I hope this makes sense and any suggestions would be greatly appreciated!
 
Hi ,


Try this :


=AND(NOT(ISBLANK(F1)),F1>40000,F1<TODAY())


where F1 is the cell which is being conditionally formatted.


40000 is an arbitrary value , where today is 41323. If you want , you can enter any relevant date , such as January 1 , 2013 or any other date in the past instead of 40000.


Narayan
 
Thank you so much, I thought ISBLANK would be involved but wasn't sure how.


Many thanks, honestly you've made my day a lot better!
 
You must log in or register to reply here.
Back
Top