All Questions
Tagged with microsoft-excel formatting
25
questions
5
votes
5
answers
18k
views
Is there a way to use Conditional Formatting on a row based on values in a single column? [duplicate]
Possible Duplicate:
Conditional formatting to highlight the whole row
I have a sheet to be conditionally formatted. I want to format the whole row based on key text. Is it possible?
2
votes
4
answers
2k
views
Excel transpose and organize
I have a bunch of rows, that I want to turn into a table.
Is there a way in Excel to convert a bunch of entries, each occupying four rows into a table, where each of the four rows is put in one of ...
2
votes
5
answers
41k
views
Protecting the formatting in Excel 2007
I'm creating a number of forms in Excel 2007 for other people to use. They will be accessing the digital versions, and I'm afraid that they'll eventually accidentally break the formatting I've ...
2
votes
2
answers
26k
views
Excel: if duplicate cell value found in another column then highlight green
Can someone help me, I'm not sure what formula to use.
I have highlighted the cell in the picture to show an example of what I mean.
What I want to do is highlight the cell in column A where the ...
1
vote
3
answers
2k
views
Excel MATCH function seems to be broken. Issue description and investigation details. Any explanation or solution to this?
I'm a fairly intensive and experienced Excel user, used to work with INDEX and MATCH functions and with strings, so I am also used to the typical issues with errors with the MATCH function due to ...
1
vote
1
answer
765
views
How to put all lines starting with a specific character combination on the previous line in Excel or Notepad++?
I'm trying to import the following CSV data set into Excel. I'm using the Text Import Wizard to set the right delimiters. So far, I used the ";" and "," delimiters.
Here is the ...
1
vote
1
answer
235
views
Changing cell color based on its contents
I have a list of car dealerships. What I'd like to do is change the color of the cell based on what type of dealership it is. So, for example, if I have the cells:
ABC Ford
DEF Chevrolet
GHI Honda
...
1
vote
1
answer
2k
views
Why is copy paste losing all formatting by default?
Lately whenever i copy paste something (in particular within Office) by default i lose all formatting. To copy the formatting have to retry copying the content several times before it works.
So far i ...
0
votes
2
answers
753
views
What is going wrong with importing and formatting the following .csv data set into Excel?
I'm trying to import the following CSV data set into Excel. I'm using the Text Import Wizard to set the right delimiters. So far, I used the ";" and "," delimiters.
Here is the ...
-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 ...