Conditional Formating Problem

M

MESTRELLA29

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.
 
B

Bob Phillips

Condition 2

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

--
HTH

Bob Phillips

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

Heather Baseler

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
 
D

Dave Peterson

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
 
G

Gord Dibben

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
 
Top