Home |
Search |
Today's Posts |
#2
|
|||
|
|||
Hi
if you want YES in I8 use the following formula =IF(H8Now(),"YES","") or if you want it red click on I8 choose format / conditional formatting choose formula is type =H8NOW() click on the format button - choose a fill colour from the patterns tab click OK twice Cheers JulieD "Justina Call via OfficeKB.com" wrote in message ... I'm looking for a formula that can give me the yes or no result in cell (I8) . Basically if Training Due is past the current date, the cell (I8) would say "yes" or not necessarly say yes but maybe rather have it color coated for complete, whichevers easier. last complete training due complete 07-Mar-04(G8) 7-Mar-05(H8) "yes" or "no" (I8) -- Message posted via http://www.officekb.com |