I'm working on a db of accounts recevable. All accounts are due on the first
of the month.
I will enter dates when paid, what I would like to do is change the color
of the date in the cell "If paid befor the First=green, First to
fifth=black, after fifth=red " for each month. The formula's I tryed will
eather work till it has to change a color ( then it stays with that color)
or it will see Feb. as "late" becouse it referes back to Jan. I'm pretty
sure I have to do each month in a different formula.
Thank You for any help you can give.
Rusty


a b c d e f g h i j
john Tim Mary
5 Jan 1/1 1/1 1/1
6Feb. 1/2 1/2 3/2
7Mar 1/3 6/3 1/3
8Apr
9May
10Jun
11Jul
12Aug