Hello:

By following this forum, I have succesfully created laternating color in
rows of my spreadsheet by using this formula: =MOD(SUBTOTAL(3,$A$7:$A7),2)=0

I need it to facilitate easy reading although there is still wakness of this
formula, because I have 35 thousand rows, ant it bocomes slow now. How eever
for the small size I need this, however I have a problem I need to have in
the same cell that if the content of the A1 < B1 it will show the read font
color. AND IT DOES NOT WORK, ANY SOLUTIONS TO THIS???

I appreciate any idea provided.

Thanks.

Frank

Add an additional condition for A1<B1, but make it condition 1.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Frank Situmorang" wrote in message
...
Hello:

By following this forum, I have succesfully created laternating color in
rows of my spreadsheet by using this formula:
=MOD(SUBTOTAL(3,$A$7:$A7),2)=0

I need it to facilitate easy reading although there is still wakness of
this
formula, because I have 35 thousand rows, ant it bocomes slow now. How
eever
for the small size I need this, however I have a problem I need to have in
the same cell that if the content of the A1 < B1 it will show the read
font
color. AND IT DOES NOT WORK, ANY SOLUTIONS TO THIS???

I appreciate any idea provided.

Thanks.

Frank

Hi Frank,
Excel 2007 can combine Conditional Formatting, but
pre Excel 2007, I believe you would need three conditions
and I'm including this as was stated. For more information on
Conditional Formatting see
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Condition 1: =AND(A1<B1,MOD(SUBTOTAL(3,$A$7:$A7),2)=0)
Condition 2: =A1<B1
Condition 3: =MOD(SUBTOTAL(3,$A$7:$A7),2)=0

If you need more than 3 conditions and don't have Excel 2007
see http://www.xldynamic.com/source/xld.....Download.html
(actually I have yet to look at Excel 2007 limits for Conditional Formatting)

This is a newsgroup not a web forum. One of the big differences
is that web forums mess up web searches. Hardly anyone who
answers many questions here would have anything to do with web forums
or web access for newsgroups.

You should be able to search Google Groups for newsgroups and only
newsgroups, and you *should* be able to use Google (web search) and
not pick up newsgroups at all (and ideally weed out the all web forums, unless
searching a specific web forum).
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"Bob Phillips" wrote ...
Add an additional condition for A1<B1, but make it condition 1.

"Frank Situmorang" wrote ...
By following this forum, I have succesfully created laternating color in
rows of my spreadsheet by using this formula:
=MOD(SUBTOTAL(3,$A$7:$A7),2)=0

I need it to facilitate easy reading although there is still wakness of
this
formula, because I have 35 thousand rows, ant it bocomes slow now.
However
for the small size I need this, however I have a problem I need to have in
the same cell that if the content of the A1 < B1 it will show the read
font
color. AND IT DOES NOT WORK, ANY SOLUTIONS TO THIS???

Thanks David for your explanation how ever I found it the result is, even the
data of A1B1 wil have the same shade format with red font. I want it shaded
and unshaded continually, but for the data A1<B1 we need it shaded and red
font color, could you explain more?

Thanks,

Frank

Hi Frank,
Excel 2007 can combine Conditional Formatting, but
pre Excel 2007, I believe you would need three conditions
and I'm including this as was stated. For more information on
Conditional Formatting see
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Condition 1: =AND(A1<B1,MOD(SUBTOTAL(3,$A$7:$A7),2)=0)
Condition 2: =A1<B1
Condition 3: =MOD(SUBTOTAL(3,$A$7:$A7),2)=0

If you need more than 3 conditions and don't have Excel 2007
see http://www.xldynamic.com/source/xld.....Download.html
(actually I have yet to look at Excel 2007 limits for Conditional Formatting)

This is a newsgroup not a web forum. One of the big differences
is that web forums mess up web searches. Hardly anyone who
answers many questions here would have anything to do with web forums
or web access for newsgroups.

You should be able to search Google Groups for newsgroups and only
newsgroups, and you *should* be able to use Google (web search) and
not pick up newsgroups at all (and ideally weed out the all web forums, unless
searching a specific web forum).
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"Bob Phillips" wrote ...
Add an additional condition for A1<B1, but make it condition 1.

"Frank Situmorang" wrote ...
By following this forum, I have succesfully created laternating color in
rows of my spreadsheet by using this formula:
=MOD(SUBTOTAL(3,$A$7:$A7),2)=0

I need it to facilitate easy reading although there is still wakness of
this
formula, because I have 35 thousand rows, ant it bocomes slow now.
However
for the small size I need this, however I have a problem I need to have in
the same cell that if the content of the A1 < B1 it will show the read
font
color. AND IT DOES NOT WORK, ANY SOLUTIONS TO THIS???

Frank,

That sounds like 4 conditions to handle all possibilities

shaded, red font
unshaded, red font
shaded
unshaded

which is not supported prior to Excel 2007. Why not just go for just 3, just
use red font or shaded/unshaded on row 1?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Frank Situmorang" wrote in message
...
Thanks David for your explanation how ever I found it the result is, even
the
data of A1B1 wil have the same shade format with red font. I want it
shaded
and unshaded continually, but for the data A1<B1 we need it shaded and red
font color, could you explain more?

Thanks,

Frank

Hi Frank,
Excel 2007 can combine Conditional Formatting, but
pre Excel 2007, I believe you would need three conditions
and I'm including this as was stated. For more information on
Conditional Formatting see
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Condition 1: =AND(A1<B1,MOD(SUBTOTAL(3,$A$7:$A7),2)=0)
Condition 2: =A1<B1
Condition 3: =MOD(SUBTOTAL(3,$A$7:$A7),2)=0

If you need more than 3 conditions and don't have Excel 2007
see http://www.xldynamic.com/source/xld.....Download.html
(actually I have yet to look at Excel 2007 limits for Conditional
Formatting)

This is a newsgroup not a web forum. One of the big differences
is that web forums mess up web searches. Hardly anyone who
answers many questions here would have anything to do with web forums
or web access for newsgroups.

You should be able to search Google Groups for newsgroups and only
newsgroups, and you *should* be able to use Google (web search) and
not pick up newsgroups at all (and ideally weed out the all web forums,
unless
searching a specific web forum).
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"Bob Phillips" wrote ...
Add an additional condition for A1<B1, but make it condition 1.

"Frank Situmorang" wrote ...
By following this forum, I have succesfully created laternating color
in
rows of my spreadsheet by using this formula:
=MOD(SUBTOTAL(3,$A$7:$A7),2)=0

I need it to facilitate easy reading although there is still wakness
of
this
formula, because I have 35 thousand rows, ant it bocomes slow now.
However
for the small size I need this, however I have a problem I need to
have in
the same cell that if the content of the A1 < B1 it will show the read
font
color. AND IT DOES NOT WORK, ANY SOLUTIONS TO THIS???

Bob,

Thankyou for your comment. The problem is red font is important to indicate
that it is an overbudget. That is what I see the weakness of the prior excell
2007 that there is no union of format

Frank


"Bob Phillips" wrote:

Frank,

That sounds like 4 conditions to handle all possibilities

shaded, red font
unshaded, red font
shaded
unshaded

which is not supported prior to Excel 2007. Why not just go for just 3, just
use red font or shaded/unshaded on row 1?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Frank Situmorang" wrote in message
...
Thanks David for your explanation how ever I found it the result is, even
the
data of A1B1 wil have the same shade format with red font. I want it
shaded
and unshaded continually, but for the data A1<B1 we need it shaded and red
font color, could you explain more?

Thanks,

Frank

Hi Frank,
Excel 2007 can combine Conditional Formatting, but
pre Excel 2007, I believe you would need three conditions
and I'm including this as was stated. For more information on
Conditional Formatting see
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Condition 1: =AND(A1<B1,MOD(SUBTOTAL(3,$A$7:$A7),2)=0)
Condition 2: =A1<B1
Condition 3: =MOD(SUBTOTAL(3,$A$7:$A7),2)=0

If you need more than 3 conditions and don't have Excel 2007
see http://www.xldynamic.com/source/xld.....Download.html
(actually I have yet to look at Excel 2007 limits for Conditional
Formatting)

This is a newsgroup not a web forum. One of the big differences
is that web forums mess up web searches. Hardly anyone who
answers many questions here would have anything to do with web forums
or web access for newsgroups.

You should be able to search Google Groups for newsgroups and only
newsgroups, and you *should* be able to use Google (web search) and
not pick up newsgroups at all (and ideally weed out the all web forums,
unless
searching a specific web forum).
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"Bob Phillips" wrote ...
Add an additional condition for A1<B1, but make it condition 1.

"Frank Situmorang" wrote ...
By following this forum, I have succesfully created laternating color
in
rows of my spreadsheet by using this formula:
=MOD(SUBTOTAL(3,$A$7:$A7),2)=0

I need it to facilitate easy reading although there is still wakness
of
this
formula, because I have 35 thousand rows, ant it bocomes slow now.
However
for the small size I need this, however I have a problem I need to
have in
the same cell that if the content of the A1 < B1 it will show the read
font
color. AND IT DOES NOT WORK, ANY SOLUTIONS TO THIS???