2 columns with dates, if date in column A is more than 1 year after column B,
then make the date in column A red. I can't get this to work. Conditional
formatting will only look at one row but not the rest of the rows. I need
something that compares relatively, eg. A2,B2; A3,B3, etc. Right now the
best I can do with conditional formatting is A2,B2; A3,B2; A4,B2; etc. Would
appreciate an email reply in addition to newsgroup reply. Thanks.