HOW DO I EDIT A CONDITIONAL FORMAT?

D

DLC

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
 
G

Guest

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
 
W

WillRn

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,
 
Top