All Questions
Tagged with microsoft-excel formatting
75
questions with no upvoted or accepted answers
0
votes
1
answer
93
views
Change Cells without Copy/Paste
Imagine the list being a lot longer... Is there a way to replace the cells in both A & B with the appropriate name/ID from Column C? "Appropriate Name" is whats in column C (match names). This is ...
0
votes
1
answer
915
views
Excel: Conditional formatting for column merge
I'm looking to create a timetable that is formed by combining material from several worksheets. It does not seem to be possible to automatically consolidate text from several worksheets, but it is, of ...
0
votes
1
answer
789
views
Excel 2013 - PC - conditional formatting with multiple sheets
I have a project that covers 2 sheets. It concerns doing inventory for small businesses.
On sheet 1 there is a schedule of inventories and purchases that a business can make each month. On sheet 2 ...
0
votes
1
answer
64
views
Excel converts datetime to other format where days are low enough to be months
I live in europe and our datetime format is usually dd/MM/yyy
I have an excel spreadsheet where I have ALOT of dates
But for reasons I do not know, Excel converts where (dd < 12) to mm/dd/yyyy - ...
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
'...
0
votes
0
answers
4k
views
excel chart data labels failing to apply to all series
if I have a multiple series chart (pivot chart to be exact, can be line or bar) and I select (from the ribbon)
layout
data labels
more data label options...
then it automatically slaps '...
0
votes
1
answer
236
views
Is there a way to copy & paste a format style in Word?
I export some data (daily) from Access to Word and each time, I need to take certain formatting steps (about 6 steps) for the final Word Document.
Instead of going through each step, one by one, each ...
0
votes
1
answer
139
views
I've deleted some cells and cleared everything out and it keeps reverting back to DATE format
I've never changed formatting to date: I always keep it in General unless I need to make it different.
Since my last Update, everything now changes to date when I either copy, paste, or when I ...
0
votes
0
answers
330
views
In MS Excel cell format, How to change the default time duration from "number of days" to "number of minutes"?
In MS excel if I set a cell format as time (e.g. [h]:mm:ss) and then if I type any number N in that cell, MS excel assume that number as number of days since 1st Jan 1900 00:00:00. Is it possible to ...
0
votes
2
answers
81
views
Formating my Excel Cell Formulas
What formula can I format my cells to so that when I input a number it will have a u after it (I have it set to ###,###u now) and if it is blank it will have "N/A" in the cell? Thank you in advance.
0
votes
1
answer
2k
views
Excel Chart data table. Formatting one row (TOTAL) only
Im trying to build a chart and Highlight TOTAL row in data table (that one underlined on screen) ;).
I can format only whole chart data table or nothing.
By a trick I did a "hidden" (no colour and ...
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 ...
-1
votes
1
answer
183
views
How to count two different column?
I really need your help regarding the below table, I need a formula to show me how many pending/closed for each project.
Project Status Project Pending Closed
VIVA closed ...
-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 ...
-2
votes
1
answer
127
views
Using Conditional Formatting, highlight a cells based on value in adjacent cells
How to highlight column B values based on corresponding Column A value using conditional formatting.
Thanks in advance
NRM