View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael Michael is offline
external usenet poster
 
Posts: 791
Default Excel Formulas Help

I may be just having a brain malfunction or 2007 Excel and I are not
communicating effectively. I have to date ranges in one of my worksheets,
colum X equals the date entered, colum Y = X +365 so I get a due date one
year from the date entered in X.

I would like to add some conditional formatting in colum X by having the
cell highlighted when the current computer date is greater than what is in X.
I am not getting the formula to work properly, any help out there?