All Questions
Tagged with microsoft-excel formatting
74
questions with no upvoted or accepted answers
2
votes
0
answers
212
views
Stacked Area Chart Excel, 3 Series Negative Problems
I am trying to create a chart similar to this original chart. I'm having troubles with the negative values. The red area falls negative when I chart it as a stacked chart.
It seems like it should be ...
2
votes
0
answers
205
views
in microsoft excel how to define a default language for columns
Hi I'm working on a dictionary and need to have English words in one column and Persian translation in another. but it takes time changing language every time I want to type the English and Persian ...
2
votes
0
answers
493
views
Percentage formatting not copied to new rows in excel table
Whenever I create a table in excel with a column with percentage formatting, the formatting never is copied to any new rows created by dragging down the bottom right corner of the table to add new ...
2
votes
0
answers
98
views
Excel 2010 clips top edge of content
In Excel 2010 on 2 different computers, the same file opens differently as follows:
Correct:
Incorrect:
The correct one is displayed first. This is a file exported from a SQL Server Report; when ...
1
vote
1
answer
382
views
How to format Y axis in an Excel chart in days, hours, minutes?
I have an Excel chart tracking time taken to complete a task. I managed to use rows in my spreadsheet to apply custom data labels for the graph, but it doesn't match up to the Y axis of my graph.
I ...
1
vote
1
answer
61
views
Excel conditional formatting highlighting different cells in range
I need to setup conditional formatting to highlight any cells in the range that are not equal to the first cell. I have attached 2 pictures the first is how the data is typically entered and I have ...
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 ...
1
vote
2
answers
72
views
Please help me stop Excel 365 enterprise from changing my text formatted cells into formulas
I have a spreadsheet where I need to use strings that contain a couple of dash/ minus ( - ) signs in cells, but it will not stop truing to recognize them as formulas! I have already formatted the ...
1
vote
3
answers
2k
views
How to reorganize vertically repeating data to horizontal?
I have data on 1 variable from 1970 to 2017 from all the countries in the world. this data is organized as one large vertical list, with first a column with the (repeating) country name, then a column ...
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
152
views
Create custom formatting for text fields in excel?
I have an issue in Excel and would like to create some custom formatting for a set of text fields. When I insert names into a spreadsheet, my source data often comes in with middle initials, surnames,...
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 ...
1
vote
1
answer
69
views
conditional formatting based on another value
I need a way to conditional format cell B based on the values of cell A.
Basically I need B to be:
Green if the values are in the same day and within the same hour of A.
Yellow if its one hour ...
1
vote
1
answer
180
views
Get conditional formatting to analyze rows separately
I have a calendar and I am trying to fill the background of the cells based on dates on another sheet.
I have gotten it to work by entering the dates in a columns, naming the range (lets says "Dates"...
1
vote
1
answer
84
views
Conditional formatting excel conundrum
I have a list of values in excel.
I would like to highlight a cell if its more than 1.5 higher or lower than the value before it or after it.
Is this possible?
Thanks guys!!