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

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

Thanks JulieD it worked perfectly.

--
Message posted via http://www.officekb.com

try format, conditional formatting for colorizations


-----Original 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
.

you're welcome and thanks for the feedback

"Justina Call via OfficeKB.com" wrote in message
...
Thanks JulieD it worked perfectly.

--
Message posted via http://www.officekb.com