How can I alternate row colors in Excel and keep the effect?－software｜痞客邦

Feb 22 Thu 2007 20:35
How can I alternate row colors in Excel and keep the effect?

close

How can I alternate row colors in Excel and keep the effect after changing
the sort order???

I don't know if there is an easier way ... but...
you could use conditional formating and the following formula.

=MOD(ROW(),2) gt; 0
this will set odd rows to whatever formating you want ...

quot;D-Lydonquot; wrote:

gt; How can I alternate row colors in Excel and keep the effect after changing
gt; the sort order???

Have a look at www.cpearson.com/excel/banding.htm

quot;D-Lydonquot; wrote:

gt; How can I alternate row colors in Excel and keep the effect after changing
gt; the sort order???

software

software

software 發表在痞客邦留言(0) 人氣()

E-mail轉寄

全站分類：不設分類
個人分類：title
此分類上一篇： Excel Booklet Protection Question
此分類下一篇： Trace Dependent Cells of the Linked Files
上一篇： Dynamic series for chart
下一篇： (Again) Converting rows to columns

歷史上的今天

2007: time
2007: Decimal point/comma issue
2007: Create button on worksheet to restore woksheets orignal values
2007: Sqlrequest only return one value
2007: formatting numbers
2007: automatic series readjustment when Inew row added
2007: Bar of Pie Chart
2007: Legend box position resetting when reopening file
2007: Excel should highlight row/column location on mouseover
2007: hiding columns or rows not using the hide function
2007: merge contents in excel
2007: How do I add an extra line to a line-column chart?
2007: Rounding Up or down to 1/2 Units
2007: Formula to a number can you tell
2007: vlookup must return a value that is greater than
2007: Variable sheet and Formula Sheet
2007: I need a template for a proforma invoice
2007: Date Day Assistance
2007: Return a value from a list in another worksheet
2007: looking for a value in a collumn
2007: How to automatically insert date when text entered in neighboring
2007: =IF problem
2007: Copy/Paste how to avoid the copy of formula cells w/o calc values
2007: Change fmt of a cell if number matches any in a range of cells?
2007: Adding dollars
2007: Autofill
2007: Looking Up Range of Numbers
2007: #DIV/0! and IF statement
2007: How to use distribution functions?
2007: is there a way of drawing floor plans within office
2007: Pivot and columns
2007: Copy and paste from last record at bottom of column
2007: TextBox Formatting
2007: How to creat log scale chart?
2007: Change value based on another cell's value
2007: COUNTIF Function
2007: Axis Data Location
2007: Change database connection between live and test for external data
2007: Get number of a cell in a list.
2007: Drop Down List Error
2007: Linking sheets into one major sheet?
2007: Extract information from the list
2007: pasting zero '0' into excel, not loose the number 08459 to 8459
2007: multiple regression in Excel12
2007: don't have a good thread title. (sumproduct?)
2007: Setting up a Custom type, User-defined, Default Chart
2007: Does anyone know, how can i write TAN^(-1) to the excel
2007: problem with import files by excel macro
2007: datasort not working properly
2007: Sum of a range dont have to be over 8
2007: Settings are changed when opening workbook on a different computer
2007: Newbie seeks suggestion on recording new macro to print sheets
2007: Tough conditional formatting question
2007: need help with locking spreadsheet
2007: date format in code
2007: how to do normality test in excel
2007: labels closer to axis
2007: vlookup with two criteria
2007: number of hours between two date/times
2007: questions re quotes and csv
2007: excel novice question on filling in missing fields/cells
2007: automatically filter for unique records... or other suggestions
2007: I lost a 20 page dockument. How do I find it?
2007: Get rid of the zeros?!
2007: ranking query
2007: How to make other cells give a specific value when entered into a
2007: Find amp; loop in VBA
2007: autofit cells in column width
2007: general macro question
2007: HTH
2007: how to use list in excel 2002
2007: Two Logic tests in an IF Statement
2007: Excel
2007: Looping in VB with cell ranges
2007: Finding concurrent events from a list with a start and an end time
2007: Vlookup gives wrong answers when used in large data. Pls advise?
2007: multiple rows with some dups where I need result on one line
2007: why after mailmerged the data can not be read?
2007: If Formula Question
2007: if statements
2007: spreadsheet for expenses and payments?
2007: shortcut to insert cells
2007: VBA help (and other) please
2007: If 2 cols meet a criteria then sum the 3rd column
2007: Can you write a formul that will put multipal answers in multipal.
2007: When I open Excel, workbooks open automatically. How can I stop t
2007: change cell color based on cell value
2007: Default Search in Workbook
2007: Copy/Paste
2007: Using time amp; data functions
2007: 《磁场--电机6005》附图3
2007: how do I break the y axis in a chart
2007: Change block range into one column
2007: Counting Unique Values
2007: Where do I obtain a rebate log templete?
2007: If cell equals, give total of another cell
2007: help
2007: quot; invalid cell references.
2007: Selecting all images in spreedsheet at once
2007: How do I correct this formula?

留言列表

站方公告

活動快報

newdirect

看更多活動好康

我的好友

熱門文章

文章分類

最新文章

最新留言

動態訂閱

文章精選

所有文章列表

文章搜尋

新聞交換(RSS)

誰來我家

參觀人氣

本日人氣：
累積人氣：

QR Code

qrcode

POWERED BY

(登入)