C
Colin Hayes
Hi
I have a couple of small questions :
1. The first one is to do with using more than one condition in
conditional formatting without having once countermand the other.
I'm using =MOD(ROW(),2)=0 to colour alternate rows down my worksheet.
I'm also trying to have negative numbers show in red by using formula ->
less then zero -> font red.
I can't , whatever I do , get this to work so that negative numbers will
be red on whichever row they appear , without changing the background
colour. Any suggestions?
2 . Also , I would like to limit the visible screen size to A1 - K27 ,
so that the visible screen won't scroll beyond these rows. Is there a
piece of code I can enter to do this?
Any help gratefully received.
Thanks.
I have a couple of small questions :
1. The first one is to do with using more than one condition in
conditional formatting without having once countermand the other.
I'm using =MOD(ROW(),2)=0 to colour alternate rows down my worksheet.
I'm also trying to have negative numbers show in red by using formula ->
less then zero -> font red.
I can't , whatever I do , get this to work so that negative numbers will
be red on whichever row they appear , without changing the background
colour. Any suggestions?
2 . Also , I would like to limit the visible screen size to A1 - K27 ,
so that the visible screen won't scroll beyond these rows. Is there a
piece of code I can enter to do this?
Any help gratefully received.
Thanks.