All Questions
15
questions
0
votes
2
answers
210
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 ...
- 1
1
vote
0
answers
237
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 ...
- 11
2
votes
5
answers
2k
views
Rotate text without rotating border
I'm attempting to rotate the text inside of a cell without altering the cell border.
Roughly the intended result:
Current Output:
The only solution I've found so far involves adding either splitting ...
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?
- 11
0
votes
1
answer
278
views
VBA Error in referencing range of another sheet via the Cells option
I have some subs I use to format data in an Excel file.
In particular, I have a sub that I can activate in the sheet("1.Parus") that has the line :
Range(Cells(2, 1), Cells(1000, 3)).Interior.Color ...
- 125
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,
...
- 11
0
votes
1
answer
102
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 ...
2
votes
2
answers
4k
views
Can you make Excel Change Another Cell's Colour When This Cell is Clicked?
I've tried Googeling but found no answers... very frustrated.
I'm trying to do this in Excel:
Select cells B1 - B5 (or just B1)
The select cell A1 (which is yellow in colour)
Cells B1 - B5 (or just ...
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 ...
- 13.4k
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(...
- 175
1
vote
0
answers
744
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 ...
- 81
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
'...
- 252
3
votes
2
answers
7k
views
Excel VBA Function for Value AND Format Lookup
I need a custom function to lookup both a cell value and copy the source format. I have a list of values in two columns. The first is of integers and the second column is the corresponding text ...
- 131
2
votes
1
answer
2k
views
Macro for helping superscript last character of many rows in a single column
I'm adding footnotes (always adding footnotes) to a table and I would really like to be able to automate the repetitive nature of making my symbols superscript.
Currently it’s: >enter cell>highlight ...
- 1,538