[j5b9721]

I need to add these into "conditional formating" section... in "conditon 2"
But dont know how to enter the formula. I keep getting error messages that
the formula is wrong.

I dont want to the "fill" in the cell if nothing is entered in "cd6"
but it needs all these in the string as logical situations also.

IF(cd6="","",OR((cd6<=-5%),(cd6<=0,cd6=-0.0499),(cd6<=-5%,Sum(ca6:cd6)=5%))

I know this is writen the long way.... (cd6<=0,cd6=-0.0499)
how do I shorten it? (cd6<=0,-0.0499)???

After adding the formula it turns the string into this...
="IF(cd6="""","""",OR((cd6<=-5%),(cd6<=0,cd6=-0.0499),(cd6<=-5%,Sum(ca6:cd6)=5%))" but it dont work corectly.

Thanks for looking & your Help!!!!

[Eduardo]

Hi,
Please provide an example of what you want to achieve, thanks

"j5b9721" wrote:

I need to add these into "conditional formating" section... in "conditon 2"
But dont know how to enter the formula. I keep getting error messages that
the formula is wrong.

I dont want to the "fill" in the cell if nothing is entered in "cd6"
but it needs all these in the string as logical situations also.

IF(cd6="","",OR((cd6<=-5%),(cd6<=0,cd6=-0.0499),(cd6<=-5%,Sum(ca6:cd6)=5%))

I know this is writen the long way.... (cd6<=0,cd6=-0.0499)
how do I shorten it? (cd6<=0,-0.0499)???

After adding the formula it turns the string into this...
="IF(cd6="""","""",OR((cd6<=-5%),(cd6<=0,cd6=-0.0499),(cd6<=-5%,Sum(ca6:cd6)=5%))" but it dont work corectly.

Thanks for looking & your Help!!!!

[j5b9721]

Hi I need this...
cd6 gives price % change, the differance between 2 days, and has a formula
in the cell =IF(CD7="","",(CD7-CC7)/CC7) to find the change.

In the "conditional formating" section... in "conditon 2" I need this to
take place.
The fill if triggered is red text and yellow background.
I only need examples of how to write these formulas using IF & OR...
(cd6<=0,cd6=-0.0499) ...this I need to know the way to write it

If cell cd6 formated if no entry is given to not color fill.
Logical 1... if cd6<=-5%
Logical 2... if cd6 is between 0 & -0.0499
Logical 3... if cd6<=-5% to "Sum(ca6:cd6) past 4 days % changes" if it's
total is =5% of the cell cd6 in to cell.

IF(cd6="","",OR((cd6<=-5%),(cd6<=0,cd6=-0.0499),(cd6<=-5%,Sum(ca6:cd6)=5%)),"")

"Eduardo" wrote:

Hi,
Please provide an example of what you want to achieve, thanks

"j5b9721" wrote:

I need to add these into "conditional formating" section... in "conditon 2"
But dont know how to enter the formula. I keep getting error messages that
the formula is wrong.

I dont want to the "fill" in the cell if nothing is entered in "cd6"
but it needs all these in the string as logical situations also.

IF(cd6="","",OR((cd6<=-5%),(cd6<=0,cd6=-0.0499),(cd6<=-5%,Sum(ca6:cd6)=5%)),"")

I know this is writen the long way.... (cd6<=0,cd6=-0.0499)
how do I shorten it? (cd6<=0,-0.0499)???

After adding the formula it turns the string into this...
="IF(cd6="""","""",OR((cd6<=-5%),(cd6<=0,cd6=-0.0499),(cd6<=-5%,Sum(ca6:cd6)=5%))" but it dont work corectly.

Thanks for looking & your Help!!!!

[David Biddulph[_2_]]

For a conditional formatting "formula is" condition you don't need IF.
If the condition you are after is (cd6<=0,cd6=-0.0499) then the formula is
=AND(cd6<=0,cd6=-0.0499) but I think that you probably intended
=AND(cd6<=0,cd6-0.05) or else otherwise you haven't covered values -0.05
but less than -0.0499. Furthermore, if your first CF test is for the
condition =cd6<=-5% you don't need to include the cd6-0.05 test in the
second condition, as the <= cases have already been trapped by the first
condition. Hence the second condition is merely =cd6<=0.
--
David Biddulph

j5b9721 wrote:
Hi I need this...
cd6 gives price % change, the differance between 2 days, and has a
formula in the cell =IF(CD7="","",(CD7-CC7)/CC7) to find the change.

In the "conditional formating" section... in "conditon 2" I need this
to take place.
The fill if triggered is red text and yellow background.
I only need examples of how to write these formulas using IF & OR...
(cd6<=0,cd6=-0.0499) ...this I need to know the way to write it

If cell cd6 formated if no entry is given to not color fill.
Logical 1... if cd6<=-5%
Logical 2... if cd6 is between 0 & -0.0499
Logical 3... if cd6<=-5% to "Sum(ca6:cd6) past 4 days % changes" if
it's total is =5% of the cell cd6 in to cell.

IF(cd6="","",OR((cd6<=-5%),(cd6<=0,cd6=-0.0499),(cd6<=-5%,Sum(ca6:cd6)=5%)),"")

"Eduardo" wrote:

Hi,
Please provide an example of what you want to achieve, thanks

"j5b9721" wrote:

I need to add these into "conditional formating" section... in
"conditon 2"
But dont know how to enter the formula. I keep getting error
messages that
the formula is wrong.

I dont want to the "fill" in the cell if nothing is entered in "cd6"
but it needs all these in the string as logical situations also.

IF(cd6="","",OR((cd6<=-5%),(cd6<=0,cd6=-0.0499),(cd6<=-5%,Sum(ca6:cd6)=5%)),"")

I know this is writen the long way.... (cd6<=0,cd6=-0.0499)
how do I shorten it? (cd6<=0,-0.0499)???

After adding the formula it turns the string into this...
="IF(cd6="""","""",OR((cd6<=-5%),(cd6<=0,cd6=-0.0499),(cd6<=-5%,Sum(ca6:cd6)=5%))"
but it dont work corectly.

Thanks for looking & your Help!!!!

[j5b9721]

Hi David...
I do understand a little about the AND formula, but my problem goes deeper
then that from what I tried to do today. I hope you will be able to help me
solve this problem as it's becoming very complicated and taxing to me also.
If you have time I will appreciate your help. It seams that I may need in CF
a multi-situation in 2 Conditions.
What I need to know is if you want me start from the beginning, or go
straight to the problem, you just may not follow whats happening with my
explination.

BZ CA CB CC CD
221 19 -65 74 --- line 4


-0.53% 1.78% -1.75% 5.89% --- line 6 Formula is
=IF(CC7="","",(CC7-CB7)/CB7)
<--- for "CC6"+

It needs CF "Condition 1" has a few given situations that are need.

Condition 1 needs... (red text only)
CC6 to be between 0% and -4.9% "TRUE"
If CC6<-5%, BY6 ... CB6 and if any is =CC6 "TRUE"
If CC6<-5%, Sum(BY6:CB6) must be 4.75% "TRUE"
If CC6<-5%, BY4 ... CB4 all must be <60 "TRUE"

Can you also help me with "Condition 2"???
Thanks for your time...
Joe


"David Biddulph" wrote:

For a conditional formatting "formula is" condition you don't need IF.
If the condition you are after is (cd6<=0,cd6=-0.0499) then the formula is
=AND(cd6<=0,cd6=-0.0499) but I think that you probably intended
=AND(cd6<=0,cd6-0.05) or else otherwise you haven't covered values -0.05
but less than -0.0499. Furthermore, if your first CF test is for the
condition =cd6<=-5% you don't need to include the cd6-0.05 test in the
second condition, as the <= cases have already been trapped by the first
condition. Hence the second condition is merely =cd6<=0.
--
David Biddulph

j5b9721 wrote:
Hi I need this...
cd6 gives price % change, the differance between 2 days, and has a
formula in the cell =IF(CD7="","",(CD7-CC7)/CC7) to find the change.

In the "conditional formating" section... in "conditon 2" I need this
to take place.
The fill if triggered is red text and yellow background.
I only need examples of how to write these formulas using IF & OR...
(cd6<=0,cd6=-0.0499) ...this I need to know the way to write it

If cell cd6 formated if no entry is given to not color fill.
Logical 1... if cd6<=-5%
Logical 2... if cd6 is between 0 & -0.0499
Logical 3... if cd6<=-5% to "Sum(ca6:cd6) past 4 days % changes" if
it's total is =5% of the cell cd6 in to cell.

IF(cd6="","",OR((cd6<=-5%),(cd6<=0,cd6=-0.0499),(cd6<=-5%,Sum(ca6:cd6)=5%)),"")

"Eduardo" wrote:

Hi,
Please provide an example of what you want to achieve, thanks

"j5b9721" wrote:

I need to add these into "conditional formating" section... in
"conditon 2"
But dont know how to enter the formula. I keep getting error
messages that
the formula is wrong.

I dont want to the "fill" in the cell if nothing is entered in "cd6"
but it needs all these in the string as logical situations also.

IF(cd6="","",OR((cd6<=-5%),(cd6<=0,cd6=-0.0499),(cd6<=-5%,Sum(ca6:cd6)=5%)),"")

I know this is writen the long way.... (cd6<=0,cd6=-0.0499)
how do I shorten it? (cd6<=0,-0.0499)???

After adding the formula it turns the string into this...
="IF(cd6="""","""",OR((cd6<=-5%),(cd6<=0,cd6=-0.0499),(cd6<=-5%,Sum(ca6:cd6)=5%))"
but it dont work corectly.

Thanks for looking & your Help!!!!