Date Query
hi,
use conditional formating.
on the menu bar, click.....Formatcontitional formating.
when the coditional fomating box comes up.....
cell value is.......less than.......=now()-10
pick your format
click ok.
regards
FSt1
"Treza Blu" wrote:
I have a spreadsheet where we input a date when we had first communication
with a potential parent/student. I want the cell to change colors when 10
days have past with no contact. In other words I want to be "alerted" when
we did not follow up with a potential client. Please explain like you are
talking to a second grader because I am a novice user, but I can get it done
if given good directions.
Many thanks!
T
|