• 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.

Date - Conditional Format

rbobcat1

rbobcat1

Member
All,

how can a place a conditional format on a column?


I have a column that monitors a dates, if the date is over 365 days the condition would be to change the cell to red
 
I should add, i have tried "format only cells that contain" then "dates Occuring" and put 365 but it doesnt work.


i should also add the cell already has a date populated in it. but when that date is 365 days past i would like the cell to change to red.
 
a date is a number. for instance, 1/1/2011 is 40544. So all dates you are entering would be bigger than 365, unless you are entering dates from the year 1900.
 
In 2007/10, when you set the criteria for conditional formatting you want to select the "use a formula to determine which cells to format" which is similar to the requirement for 2003.


Then you need to work out a formula that will drive a TRUE/FALSE answer. in this case, I suggest:

=TODAY()-cell>365

where "cell" would be the active cell in the range you have selected e.g. if you select column B and Cell B2 is highlighted then it would be B2.
 
walla, great it worked. i did start playing with =today() last night but could not get it right. i tried using +365, -365 but never thought of using the greater than. dah


Thx
 
You must log in or register to reply here.
Back
Top