I have the folowing condition formating
condition 1 =$N$5/$D$5=100% Aply green pattern
condition 2 =$N$5/$D$5<1%100% Aply yellowpattern
condition 3 =$N$5/$D$5=0% Aply whitepattern

The first 2 conditions work well, wen the formula results in 0 the patterns
that is return is yellow, what am i doing wrong.

Reverse the order, condition 3 to 2 and 2 to 3


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=559044

EXCELENTE IT WORKS...

GRACIAS

"Bearacade" wrote:


Reverse the order, condition 3 to 2 and 2 to 3


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=559044

Condition 2

=AND($N$5/$D$50%,$N$5/$D$5<100%)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"MESTRELLA29" wrote in message
...
I have the folowing condition formating
condition 1 =$N$5/$D$5=100% Aply green pattern
condition 2 =$N$5/$D$5<1%100% Aply yellowpattern
condition 3 =$N$5/$D$5=0% Aply whitepattern

The first 2 conditions work well, wen the formula results in 0 the
patterns
that is return is yellow, what am i doing wrong.

Can you help me with an issue I'm having?

I've a need to convert some numeric data into alpha such that: if cell
contains 1 then replace with "Yes". I'm not making headway with the
conditional formating. Can you help me?

Heather

"Bob Phillips" wrote:

Condition 2

=AND($N$5/$D$50%,$N$5/$D$5<100%)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"MESTRELLA29" wrote in message
...
I have the folowing condition formating
condition 1 =$N$5/$D$5=100% Aply green pattern
condition 2 =$N$5/$D$5<1%100% Aply yellowpattern
condition 3 =$N$5/$D$5=0% Aply whitepattern

The first 2 conditions work well, wen the formula results in 0 the
patterns
that is return is yellow, what am i doing wrong.

Conditional formatting won't help here.

Maybe you could just select the column and do:
edit|replace
what: 1
with: Yes
replace all

Make sure that "Match entire cell contents" is checked (under the Options button
on the edit|Find dialog)



Heather Baseler wrote:

Can you help me with an issue I'm having?

I've a need to convert some numeric data into alpha such that: if cell
contains 1 then replace with "Yes". I'm not making headway with the
conditional formating. Can you help me?

Heather

"Bob Phillips" wrote:

Condition 2

=AND($N$5/$D$50%,$N$5/$D$5<100%)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"MESTRELLA29" wrote in message
...
I have the folowing condition formating
condition 1 =$N$5/$D$5=100% Aply green pattern
condition 2 =$N$5/$D$5<1%100% Aply yellowpattern
condition 3 =$N$5/$D$5=0% Aply whitepattern

The first 2 conditions work well, wen the formula results in 0 the
patterns
that is return is yellow, what am i doing wrong.




--

Dave Peterson

Heather

CF will not change data from one form to another. It is for formatting only.

There are formulas that will do what you want, but a larger sample of your needs
would help.

For your example.............A1 contains the value 1

In B1 enter =IF(A1=1,"Yes","Not Yes")

But, I assume there is more to it than that.


Gord Dibben MS Excel MVP

On Fri, 13 Oct 2006 12:56:02 -0700, Heather Baseler <Heather
wrote:

Can you help me with an issue I'm having?

I've a need to convert some numeric data into alpha such that: if cell
contains 1 then replace with "Yes". I'm not making headway with the
conditional formating. Can you help me?

Heather

"Bob Phillips" wrote:

Condition 2

=AND($N$5/$D$50%,$N$5/$D$5<100%)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"MESTRELLA29" wrote in message
...
I have the folowing condition formating
condition 1 =$N$5/$D$5=100% Aply green pattern
condition 2 =$N$5/$D$5<1%100% Aply yellowpattern
condition 3 =$N$5/$D$5=0% Aply whitepattern

The first 2 conditions work well, wen the formula results in 0 the
patterns
that is return is yellow, what am i doing wrong.