All Questions
Tagged with formatting microsoft-excel
241
questions
0
votes
1
answer
59
views
How can be column incluted into rows?
There is the table in MS Excel or LO Calc.
How can be it converted to this view of the table?
The transformation using links (within the same table) to the initial version is allowed.
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
0
answers
2k
views
Excel - paste *only* number formatting
Is it possible to copy/paste only number formatting in Excel.
There are various paste special options.
In particular Formulas/Number Formats and Values/Number Formats. But is there a way to paste only ...
0
votes
1
answer
1k
views
Fill a cell when empty, and past a date in another column
I need a cell in column "B" to fill red, if it is empty and the date is past the date on column "M"
I have tried googling it, and there are no answers to help.
Thanks for your help
2
votes
0
answers
221
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 ...
0
votes
3
answers
231
views
Data Formatting in Microsoft Excel: Cell formatting, Text formatting, and Number Formatting [closed]
Formatting text or numbers can make them appear more visible especially when you have a large worksheet.
Formatting in Excel is a simple process of modifying or manipulating data in spreadsheets from ...
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 ...
-2
votes
1
answer
48
views
How to use conditional formatting in excel for a crosstabbed table with multiple conditions?
I am having trouble in excel using conditional formatting for my table. I need to highlight the sample values that are greater than screening_1 or screening_2 for each individual row.If the value is ...
0
votes
1
answer
2k
views
Conditionally formatting left align for a cell with text thats separated by multiple lines
I'm trying to write conditional formatting that will handle left aligning text in a cell that is normally in a range that's centered. The data in the cell could look like the following with each line ...
1
vote
1
answer
3k
views
How can I get Excel to use conditional formatting per day of the week using dates and not the words "Monday, Tuesday,"
I am working on a delivery schedule for the company I work for and we want to be able to have the dates color coded by days of the week. But we often have several deliveries on the same date, so when ...
1
vote
1
answer
4k
views
Removing outer white space around a bar graph
It might be a bit of a simple question but on
I want to remove the outer white space around the graph but I have no idea if its possible or how to do this. Any help woule be appreciated.
0
votes
2
answers
30
views
Excel - Total Count of multiple reasons
Ideally, I am looking for a solution where I can see the total number of reasons why the device failed, which is currently recorded in a dropdown list on excel (with option for multiple entries). When ...
-1
votes
2
answers
246
views
MS excel not coping data in correct format from csv file
I am coping data from csv file
it contains tables
in that table there is column name PostedDate
when i copy that PostedDate column in excel it shows wrong formatting (ie instead of / it shows -)
...
0
votes
1
answer
440
views
Can't remove hidden characters?
I'm trying to make a simple tool for my job where I can decline job listings for a specific reason simply by checking their boxes and then copying and pasting the final cell where it will compile all ...
0
votes
1
answer
80
views
Formatting whole and decimalised numbers differently in Excel
I'm having some difficulty formatting some data correctly and after looking around extensively in similar threads such as here, I've come looking for help.
I have two similar datasets (X and Y) and ...