All Questions
10
questions with no upvoted or accepted answers
1
vote
0
answers
244
views
Excel VBA Macro: Formatting Duplicates and Uniques
I have a spread sheet where each row consists of information about a member of a group. In each cell of column B there is an integer that represents each person (i.e., think of an member ID). All ...
1
vote
1
answer
71
views
How to make dependent cells follow decimal formatting of parent cell that changes from time to time?
I need dependent cells in an Excel worksheet to follow the decimal formatting of a parent cell. I've done this with format painter, but my parent cell decimal requirements change from time to time,
...
1
vote
0
answers
746
views
Format datatable using VBA (values are as Double but String is needed for formatting)
Currently working on a vba script that makes charts automatically. I would like to add a datatable which is done using:
.HasDataTable = True
However I would like to show the values of series as ...
0
votes
2
answers
217
views
How do I format a target cell based on a source cell, using VBA?
I'm looking to copy the format of a cell within the table table1 to cells with matching text within the second table table2.
So for instance: NOT(H) is showing as green in table 1 and I want it to ...
0
votes
1
answer
81
views
Excel 2013 fails to record macro correctly
So, i want to create a macro that will set selected cells' format to 0,0 ¥.
However, if you record the steps and then try to run the macro it will set format to 0,0 ?. Is there a way to fix this?
0
votes
1
answer
105
views
Excel, Return a color depending on two other cells text
I need to do an analysis in Excel and I would like to color a cell depending on the text of two other cells. I have to do it for a quite big table, therefore I need a way to not do it manually for ...
0
votes
0
answers
49
views
Formatting dates in Access
I'm embarrassed with a seemingly very simple problem. I have about 7 million of rows in Access, with a date column formatted as numbers. They are the 5 digit type of numbers excel uses when dates are ...
0
votes
1
answer
1k
views
How do I insert thousands-separators without affecting significant figures in Excel?
I need to figure out how to add thousands separators to large spreadsheets without affecting the amount of significant figures or the dates that are also in the tables. I can't figure out how to use ...
0
votes
2
answers
96
views
Autosize cell after return of function
I have an xla with a bunch of functions. Basically each of these functions perform a vertical lookup on another worksheet. Here's a basic example of one of them:
Function ax2Project_Address(...
0
votes
0
answers
1k
views
How to change the colours of sparkline axes individually
I found the following code (in the office docs) which allows me to change the axis colour of a group of sparklines:
Sub AxisColor()
'The sparkline group
Dim oSparkGroup As SparklineGroup
'...