J
Jim Peterson
Hi everyone and thanks in advance for any help you can offer.
I am using XP Pro and Office 2003.
I want to form an IF formula that will look at the data in cell A2. A2 is
formatted for dates and will have a date in it. We are entering the date
membership dues have been paid through.
If the date is before (i.e. less than) 12/31/08, I want the IF formula to
fill cell A2 with Yellow color. This will highlight to us that someone has
not paid their current dues. If the date is after 12/31/08 (i.e. greater
than) it will leave the cell with no fill.
Is there any way to make this happen?
Again, thanks for any help or ideas. You guys always seem to pull through
for me!
Jim
I am using XP Pro and Office 2003.
I want to form an IF formula that will look at the data in cell A2. A2 is
formatted for dates and will have a date in it. We are entering the date
membership dues have been paid through.
If the date is before (i.e. less than) 12/31/08, I want the IF formula to
fill cell A2 with Yellow color. This will highlight to us that someone has
not paid their current dues. If the date is after 12/31/08 (i.e. greater
than) it will leave the cell with no fill.
Is there any way to make this happen?
Again, thanks for any help or ideas. You guys always seem to pull through
for me!
Jim