Conditional Formatting

I don't really understand what your formula is doing. I have a formula in the cell that gives me the number of days, it takes the date that has been entered into one cell and subtracts it from todays date and gives you the number of days until that day. That is why I was using the conditional formatting. I am not real sure what you want me to do with the formula you gave me.

A1=3-20-07 B1=A1-Today()
A2=3-25-07 B2=A2-Today().........I have other stuff after this that makes the value in column B give you # of days until the date in A1.

The formula Carim posted is the formula you should use in conditional formatting. Use Formula Is, and use his posted formula.

Jason

Well I guess that was easy enough. I just couldn't get it....it works great by the way.


Thanks for the help
Josh