All Questions
Tagged with microsoft-excel formatting
241
questions
0
votes
1
answer
55
views
Can I use conditional formatting in an Excel PivotTable to format cells based on specific fields?
I have the results of numerous tests run on several sub-samples. Many sub-samples make up a sample. Between 5 and 10 samples make up a lot, and I have five lots I'm trying to analyze.
Each one of ...
1
vote
2
answers
1k
views
Highlight rows with identical data in Excel
I have a number of rows within a large spreadsheet that have some identical rows I would like those rows highlighted but only if every cell on the row matches, if random cells from different rows ...
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,
...
0
votes
2
answers
98
views
How to manipulate dates?
How can I change a date in an Excel file
to eliminate the day and be left with only the month and year?
E.g., convert 4/4/2019 to April-2019?
I am aware that I can change the format, but if I do so, ...
1
vote
1
answer
26
views
Decimal Display
I'd like to display decimals in the following way:
3 = 3.00
3.1 = 3.10
3.111 = 3.111
3.111000 = 3.111
Basically a min of 2 decimals, but more decimals displayed if necessary. The exception is if ...
0
votes
0
answers
2k
views
Print / Print Preview does not match normal view for Excel worksheet
I've got a certain worksheet that will not print correctly. An image that takes up a certain amount of space in the normal view looks very different in the Print Preview view. This is the case with ...
2
votes
2
answers
2k
views
Excel Conditional formatting and Offset
I cannot get conditional formatting to copy to the right (with paint brush) because excel references the wrong cells when copied. This is what I need to achieve:
A1 needs to be formatted if Sheet2!E4=...
18
votes
1
answer
74k
views
Stop Excel chart from changing series formatting
I have an Excel bar chart that is formatted exactly the way I like it. The bar colors, the label fonts, the grid lines, etc, etc.
Here is an example:
Notice the awesome formatting of the second ...
0
votes
0
answers
117
views
Excel Chart - show data formatted regardless the local settings
I want to share a excel file with charts on a different computer.
The data I have formatted to display with thousand (,) and decimal (.) separation char.
Unfortunately the other computer is set up ...
3
votes
2
answers
630
views
Format telephone numbers in Excel
I have a column of numbers in the format
'+43 ??? ?? ??
(the ' is there so Excel doesn't think it's a formula and ? represents an integer)
which I would like to have in the format
'+43 ?? ??? ??
...
0
votes
1
answer
1k
views
Format blank cells based on text in another cell
I would like to apply conditional formatting to a sheet, however, cant figure out the right formula.
The formatting would only apply to BLANK cells in columns S to AT based on text in in column I.
...
0
votes
1
answer
1k
views
How does Increase decimal and Decrease decimal work in Excel
How the increase decimal operation is performed in Excel and how they done it?
Case 1 :
I enter a number in a cell whose number of digit is less than 11.
For instance A1 cell value be : 123
If I ...
0
votes
2
answers
89
views
Excel 2016 time formatting cells
Using Excel 2016, I want to enter 90 minutes as 90:00, or 75 minutes and 33 seconds as 75:33, or 102 minutes and 54 secs as 102:54; then sum the column to report as 268:27. How do I format the data ...
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 ...
-1
votes
2
answers
725
views
Excel conditional formating: use fill color based on a different cell's existing fill color
The following table represents the value I’m working with in Microsoft Excel.
+---+----+-----+---------+-----+
| | A | B | C | D |
+---+----+-----+---------+-----+
| 1 | | Min | ...