Hi there, I searched thru the posts and found some really good answers to
other questions I have, but I'm still having trouble with one thing. So far I
have found only solutions to conditionally formatting dates if they are based
off of today's date, i.e., "I want it to turn green a year from now". I have
query results pulled from Access that I would like to do a few things. My
first column has the date which a work order was last issued. The second
column is the date the work order was closed. I would like, for any date
listed, if it is longer than 30 days between the dates, for it to turn red. I
didn't know how or if I could do this for an entire column, because I have
hundreds of dates to compare and it would be illogical for me to format each
set of dates individually. I apologize if my question is overstated and the
answer is inanely simple, I am really not familiar with Excel formulas. I
appreciate your help!
--
Aaron Regular, Dissent Records
www.nbtnc.com