Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel workbooks in different windows & Fill color?
Q1
Hi, how to make excel workbooks opens in different windows? When I'm using Word all files opens in different windows and I can close each window without Word finish. Q2 How do I get different fill-colors other than those listed in the cell - format - meny? I got an english template with light grey-cells, worked all right yesterday, but today all cells with that color has become light-green. The light-grey color does not show up in the format meny - Weird! Q3 It's easy to format a cell with colors depending on values eg., but how do I cange the entire row color or several cells depending on a cells value in another row? |
#2
|
|||
|
|||
RR
1. ToolsOptionsView. "Windows in Taskbar" 2. ToolsOptionsColorModify. 3. Select the rows or cells first then FormatConditional FormattingFormula is: Assuming row 1 is selected enter =$D2=value where D2 is the other cell. Gord Dibben Excel MVP On Tue, 5 Apr 2005 15:25:02 -0700, "RR" wrote: Q1 Hi, how to make excel workbooks opens in different windows? When I'm using Word all files opens in different windows and I can close each window without Word finish. Q2 How do I get different fill-colors other than those listed in the cell - format - meny? I got an english template with light grey-cells, worked all right yesterday, but today all cells with that color has become light-green. The light-grey color does not show up in the format meny - Weird! Q3 It's easy to format a cell with colors depending on values eg., but how do I cange the entire row color or several cells depending on a cells value in another row? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
Opening DBF files with Excel 2003 via Windows Explorer ? | Setting up and Configuration of Excel | |||
How can I get existing Excel workbooks to open in separate windows | Excel Worksheet Functions | |||
To stop Excel from opening many workbooks at startup | Excel Discussion (Misc queries) | |||
EXCEL Workbook tab format options: change color or font | Excel Discussion (Misc queries) |