HOW DO I EDIT A CONDITIONAL FORMAT?

HOW DO I EDIT A CONDITIONAL FORMAT?

Post by RExD » Sat, 25 Sep 2004 04:03:02


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
 
 
 

HOW DO I EDIT A CONDITIONAL FORMAT?

Post by Frank Kabe » Sat, 25 Sep 2004 04:20:03

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



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

 
 
 

HOW DO I EDIT A CONDITIONAL FORMAT?

Post by anonymou » Sat, 25 Sep 2004 04:24:49

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
 
 
 

HOW DO I EDIT A CONDITIONAL FORMAT?

Post by V2lsbFJ » Wed, 27 Oct 2004 02:37:06

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,