IF formula returning a colored cell
 

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

IF formula returning a colored cell
 

You can't do it with an IF formula as such, but you can use
Conditional Formatting. Select A2 then click on Format | Conditional
Formatting and follow through the dialogue boxes.

Hope this helps.

Pete

On Sep 15, 4:17*pm, Jim Peterson
wrote:
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

IF formula returning a colored cell
 

Select the cellGo to Format | Conditional Formatting | in the first drop
down select Formula Is | in the second box type =$A$2<"12/31/2008"

Click on FormatPattern tabSelect the colorHit OK.

This should do what you want to do.


"Jim Peterson" wrote in message
...
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

IF formula returning a colored cell
 

=$A1<39813


"Jim Peterson" wrote:

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

IF formula returning a colored cell
 

Thanks everyone. That works!

"Teethless mama" wrote:

=$A1<39813


"Jim Peterson" wrote:

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