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

Hi

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

--
Regards

Roger Govier


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

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

"Roger Govier" wrote:

Hi

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

--
Regards

Roger Govier


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

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?

"romelsb" wrote:

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

see thread
"http://www.microsoft.com/office/community/en-us/default.mspx?query=romelsb&dg=microsoft.public.exc el.worksheet.functions&cat=en-us-excel&lang=en&cr=US&pt=f3f7ac8a-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

"daddylonglegs" wrote:

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?

"romelsb" wrote:

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

Are you fishing for homework answers?

--

HTH

Bob Phillips

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

"romelsb" wrote in message
...
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
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

"daddylonglegs" wrote:

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?

"romelsb" wrote:

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

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

"Bob Phillips" wrote:

Are you fishing for homework answers?

--

HTH

Bob Phillips

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

"romelsb" wrote in message
...
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
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

"daddylonglegs" wrote:

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?

"romelsb" wrote:

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