B
Bob Umlas
Use conditional formatting. Select the whole columns, say
that's C, then use Format/Conditional Format,
change "cell Value is" to "formula is", and enter
=c1<today(), then click patterns, click a Red pattern &
OK your way out... When a date is past due, it'll turn
red.
that's C, then use Format/Conditional Format,
change "cell Value is" to "formula is", and enter
=c1<today(), then click patterns, click a Red pattern &
OK your way out... When a date is past due, it'll turn
red.