I've successfully entered a conditional format. I'd like to copy this cel

and edit the conditions in the copied cel, but I've been unsuccessful. Any

suggestions?

Below is a copy of the conditional format. It searches u2:u75 for SEPTEMBER

2000, and then searches Q2:Q75 for a specific product type (141 2-way). It

then sums all 141 2-way sold in September 2000. I'd like to be able to copy

this cel and change SEPTEMBER to OCTOBER, for example. When I make this

change, a value of 0 is returned.

=SUM(IF(Shipped!$U$2:$U$75="SEPTEMBER 2000",IF(Shipped!$Q$2:$Q$75="141

2-WAY",Shipped!$C$2:$C$75,0),0))

Dan

Hi

what is your changed formula?. Not possible to do this automatically

2000",IF(Shipped!$Q$2:$Q$75="141

what is your changed formula?. Not possible to do this automatically

2000",IF(Shipped!$Q$2:$Q$75="141

check your cell column references in the new cell

conditional format statement. If SEPTEMBER data is in col

U etc., maybe OCTOBER should reference col V etc. (or some

such).

hope this helps

to copy this cel

unsuccessful. Any

u2:u75 for SEPTEMBER

type (141 2-way). It

to be able to copy

When I make this

$Q$2:$Q$75="141

conditional format statement. If SEPTEMBER data is in col

U etc., maybe OCTOBER should reference col V etc. (or some

such).

hope this helps

to copy this cel

unsuccessful. Any

u2:u75 for SEPTEMBER

type (141 2-way). It

to be able to copy

When I make this

$Q$2:$Q$75="141

I was able to do this cell by cell with the following method:

1. Click the cell containing the Conditional Sum formula you wish tp edit.

you conditional formula should appear above the spread sheet in the "Formula

Bar."

2. Highlight and change the condition you want the new formula to contain.

(i.e. replace "SEPTEMBER" with "OCTOBER"

3. Click the equals sign ("Edit Formula") next to the formula bar to bring

up the wizard.

4. Without editining anything, just click the "OK" button and your

Conditional Sum will reset using the value(s) you changed.

Hope this helps,

1. Click the cell containing the Conditional Sum formula you wish tp edit.

you conditional formula should appear above the spread sheet in the "Formula

Bar."

2. Highlight and change the condition you want the new formula to contain.

(i.e. replace "SEPTEMBER" with "OCTOBER"

3. Click the equals sign ("Edit Formula") next to the formula bar to bring

up the wizard.

4. Without editining anything, just click the "OK" button and your

Conditional Sum will reset using the value(s) you changed.

Hope this helps,

1. My I's are coming up i's. (lower case)

2. Conditional count in range w/#N?A's

3. Conditional Formatting - Can I select a select with Conditional Formatting?

4. Conditional Formatting - I just don't see what I'm doing wrong

5. Conditional Formatting - I just don't see what I'm doing wrong.

6. How to permit user B to edit user A's meeting, Public Folder

7. Losing OnAfterChange and Conditional Formatting after initial edit

8. conditional format based on button failed after editing href and

9. conditional format based on button failed after editing href

11. Conditional Formatting No Longer Conditional in 2007 Beta

12. Conditional Formatting that will display conditional data

13. Multiple conditional on conditional format formula

14. Conditional series... Conditional format

15. How do I do a complex conditional in a conditional formatting formula

4 post • Page:**1** of **1**