IF formula returning a colored cell

[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

 

[Pete_UK]

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

 

[Gaurav]

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

Click on Format>Pattern tab>Select the color>Hit OK.

This should do what you want to do.

 

[Teethless mama]

=$A1<39813

 

[Jim Peterson]

Thanks everyone. That works!

=$A1<39813