Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
uisng two paramaters for conditional formatting / Limiting screen size
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Work sheet size relative to screen size | Excel Discussion (Misc queries) | |||
Limiting size field MS query returns | Excel Discussion (Misc queries) | |||
How Do I Autofit To Screen Size | Excel Worksheet Functions | |||
How can I set the screen size to always display @ 110%- a default | Excel Discussion (Misc queries) | |||
why cant i change font size when i use conditional formatting? | Excel Discussion (Misc queries) |