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