To see the colors, go to the visual basic editor. Hit the help question mark. Type ColorIndex. From the list of topics, select the one called "ColorIndex Property". They have a nice visual table at the bottom of this help topic.
You could also build a color table with a quick macro
Public Sub ColorTable()
For i = 1 To 56
Range("A" & i).Interior.ColorIndex = i
Range("B" & i).Value = i
Next i
End Sub
How can I get Excel to accept an entry like "5+5" without the leading equals sign as a formula? I have done this is the past but can not remember how.?
How can I speed up my Macro execution?
How can I make the screen stop flashing during macro execution?
How can I format a worksheet to have alternating green and white rows like a "greenbar" report?
How can I show the complete path and filename in the Excel title bar?
How can I copy the name of the worksheet tab to a cell in the worksheet?
Hey! Excel used to have letters to indicate the columns. Now, all of a sudden, there are numbers for the columns?
I have a column of numbers in the format 99999-99999. What is a simple macro to remove the dash?
Is there a way to determine the last active column in a spreadsheet?
Is there an easier way to change formula results to fixed values in Microsoft Excel? I usually copy the cells that I am working with and then use the paste special command to past the permanent values over the original formulas?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
