Sir
I have a list object in excel.
i want to make the alternate rows of the list object to display different background color
pls let me know
list object
Hot Topic
- Access 2003 - programming arrow keys with combo box
- Word 2002 VBA weird Find problem
- MS Vista partnership/marketing program
- Displaying modeless userform while other workbooks are opened and closed
- Linking Outlook to Excel
- Changing document names
- Defining a range according to the number of responses
- DLL/OCX Redirection from Word template
- close excel when finish
- Trouble signing up for the Microsoft Empower for ISVs
Microsoft ISV
- Accessing a subform control in MS Access
- outlook code modification
- MSDN Subscription special $375.00 ?????
- Loosing Reference to Common Objects (i.s. VBA)
- How to check the TCP/IP checkbox in network connection property window?
- Export an Access Table to a csv file
- Error On Execution
- Deployement project build ERROR - URGENT!
- What's your experience with the buddy program?
- Positioning DialogSheets
list object
Robert Simpson
ukhobson
Per our support engineer:
Thanks for using Microsoft ISV Community Forum, according to your problem, I think you can take the following steps to achieve what you want:
1. Select the whole list object.
2. From the menu, choose Format>Conditional Formatting.
3. Set the value just as the picture below, choose your preferred color.
[screen shot not displayed - I'll try to recreate the text in the screen shot...]
Condition 1: Formula Is =MOD(ROW(),2)=0
Preview: [choose your preferred color]
Condition 2: Formula Is =MOD(ROW(),2)=1
Preview: [choose your preferred color]
-brenda (ISV Buddy Team)