All Questions
Tagged with microsoft-excel formatting
75
questions with no upvoted or accepted answers
0
votes
1
answer
191
views
Highlight cell based on whether or not a specific word appears in a given range?
I have 2 sheets. Sheet1 & Sheet2.
Sheet 1 has a list of items with descriptions & specific numbers.
Sheet 2 has a table filled with the same items.
What I am wanting to do, is highlight a ...
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
1
answer
97
views
How can I add a symbol after a set amount of words in Word? (Or any other program)
So I have this huge list of words that are unordered in any way. All formatted the same way. They're all just words like in the example below:
"Word1"
"Word2"
"Word3"
Now I need to put a symbol ...
0
votes
1
answer
506
views
Custom number format that takes number input and outputs related text?
I have a table T1 where a number matches a name, basically the look-up table. In another table T2 I want to input just the number, and Excel should fill in the corresponding name in the same cell. The ...
0
votes
2
answers
313
views
How to change a Generally formatted "20170824 08:45:58:544" into a Time formatted hh:mm:ss.ss?
The title is the gist of my problem. I've got a couple of thousand of these I need to convert into a hh:mm:ss.ss format while retaining (though not showing) the yyyymmdd converted to a mm/dd/yyyy ...
0
votes
1
answer
358
views
How to transform this "7.33E+11" to a standard number (i.e. UPC code)
I have a difficulty with transforming this 7.33E+11
in Excel. I had many rows with 6,22357E+11 which I can easily transform to number and it is all fine, but what happens with the one with the "." ...
0
votes
1
answer
657
views
how to allow only specific format with data validation (hh:mm - hh:mm - shift scheduling)
so basically I need a formula which allows only data in the following format:
hh:mm - hh:mm (this is for shift scheduling, so e.g. 08:00 - 16:00)
Space before and after dash (-) is absolutely a ...
0
votes
0
answers
54
views
In MS Excel Is there any way to use number formatting on entries with a mix of letters and numbers?
I'm trying to decimal justify a list using the number formatting, but the numbers in question happen to have letters in them, and they're being ignored. Is there any way to get Excel to recognize ...
0
votes
1
answer
720
views
Turn third cell red if preceding 2 cells = <1 for any consecutive 2 cells in all rows (12 rows in total) meeting this criteria
I am hoping to put together an attendance sheet which highlights a third or fourth cell in a row (12 cells for a 12 week semester) where the preceding 2 cells have values less than 2.
Basically what ...
0
votes
1
answer
479
views
How to FIX a RAND-BETWEEN Alternative Macro in Excel
I am looking for a RandBetween Altermative that has the exact same function but remains constant. I was looking for a macro that woould do just that and I thought I found one...
Function RndInt(...
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
0
answers
87
views
Formatting similar MSWord (pasted from MSExcel) tables in batch
I've got a lot of similar spreadsheets (same dimensions, different numbers) in Microsoft Excel, like this:
To present them in my report in Microsoft Word, I have to format them in this way:
To ...
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
0
answers
1k
views
x axis formatting with dynamic excel chart
I'm having a problem with a dynamic x,y chart.
I set up named ranges using this method:
My x axis label is "time" =OFFSET(graf!$D$2,0,0,COUNTA(graf!$D$2:$D$1000)-1)
I do the same for my data (y ...
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(...