USERS - NESTED IFs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

romelsb - 21 Oct 2006 22:19 GMT

Is it possible to use the named "nested If's", in the conditional format ?

Reply to this Message

Roger Govier - 21 Oct 2006 22:38 GMT

Hi

What are >the named "nested If's", ?

Signature

Regards

Roger Govier

> Is it possible to use the named "nested If's", in the conditional
> format ?

Reply to this Message

romelsb - 21 Oct 2006 23:03 GMT

I just read it from www.cpearson.com/excel/nested.htm... but I like to know
its Users if it can be applied to conditionally format a single cell. tks for
the reply..

> Hi
>
> What are >the named "nested If's", ?
>
> > Is it possible to use the named "nested If's", in the conditional
> > format ?

Reply to this Message

daddylonglegs - 21 Oct 2006 23:08 GMT

I'd suggest you describe specifically what you want to do rather than ask
generalised questions.

You want to conditionally format a single cell - what are the conditions?

> Is it possible to use the named "nested If's", in the conditional format ?

Reply to this Message

romelsb - 21 Oct 2006 23:19 GMT

see thread
"http://www.microsoft.com/office/community/en-us/default.mspx?query=romelsb&dg=mi
crosoft.public.excel.worksheet.functions&cat=en-us-excel&lang=en&cr=US&pt=f3f7ac
8a-4ea0-4c36-bed9-8feae6d75298&catlist=&dglist=&ptlist=&exp=&sloc=en-us"
for similarities to my problem, the 4 years stated requires to build up
automatically and at the same time updating the colors of cells filled with
US$ values, showing the real life consumed money and the remaining money to
be distributed til the end of the last year....I can send a scenario so u can
visualize, can i send email...I know you're brain user...thanks

> I'd suggest you describe specifically what you want to do rather than ask
> generalised questions.
>
> You want to conditionally format a single cell - what are the conditions?
>
> > Is it possible to use the named "nested If's", in the conditional format ?

Reply to this Message

Bob Phillips - 21 Oct 2006 23:33 GMT

Are you fishing for homework answers?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

> see thread

"http://www.microsoft.com/office/community/en-us/default.mspx?query=romelsb&
dg=microsoft.public.excel.worksheet.functions&cat=en-us-excel&lang=en&cr=US&
pt=f3f7ac8a-4ea0-4c36-bed9-8feae6d75298&catlist=&dglist=&ptlist=&exp=&sloc=e
n-us"

> for similarities to my problem, the 4 years stated requires to build up
> automatically and at the same time updating the colors of cells filled with
[quoted text clipped - 8 lines]
> >
> > > Is it possible to use the named "nested If's", in the conditional format ?

Reply to this Message

romelsb - 21 Oct 2006 23:45 GMT

yah... real Work...hope u dont mind...

> Are you fishing for homework answers?
>
[quoted text clipped - 30 lines]
> > > > Is it possible to use the named "nested If's", in the conditional
> format ?

Reply to this Message