Formatting Underlines
Jan 17, 2007I have a cell formated as a %. Is there a way to underline it with single or double accounting underlines as opposed to using the bottom border?
View 9 Replies
ADVERTISEMENT
Bolds / Italics And Underlines To HTML Tags
May 3, 2013I have multiple excel sheets wherein the content has bold, italic, underlined, normal text. I want to replace such texts with relevant html tags.Example is below
Identify the adjective in the following sentence. Can you please pass me the black pepper?
should change to
Identify the <b>adjective</b> in the following sentence. <i>Can you please pass me the black pepper?</i>
Conditional Formatting - Two Different Fields Affect One Cells Formatting For Date?
Sep 16, 2013A little background on what i am doing. I have a spreadsheet that tracks when i have blown the dust out of our computers. I have set up conditional formatting so that the text turns red after 300 days and the cell turns yellow after 600 days. However, some computers are in high dust environments. I would like the spreadsheet to tell me to blow the dust out of these sooner. see the attached sheet.
dust 1.xlsx
Bank Statements - Formatting / Cell Formatting Won't Change?
Mar 22, 2013I'm trying to analyse all of my bank statenments to see where all my money went!! I've got online banking so I thought it would be a relatively easy process of copying and pasting each month into excel.
Well, that in itself was easy, the problem is with the formatting of the financial numbers. Excel doesn't seem to recognise them as numbers, so at the moment I can't do any manipulation with the numbers. I have tried everything such as:
Format Cells > Number > Number and Currency
Copy and Paste Special > Values only
Copying into Notepad and back into Excel
Even if it appears to have changed the numbers to 'number' or 'currency' formatting by right justifying the numbers, if I try to add up the numbers using the SUM function, it doesn't want to know.
For some reason nothing seems to work - what am I missing?
For an example, I have attached a snippet of the spreadsheet with my starbucks transactions.
IF Statement Using Formatting Criteria (NOT Conditional Formatting)
May 5, 2009Is there "code" for different formatting in a spreadsheet so you can use an IF statement to do something like:
if(A1=blue background,"Yes","No")
or
if(A1=red text,"Yes","No")
etc.?? But replace "blue background" and "red text" with some sort of number code? I want to compile a list of the items that are formatted with certain background colors and/or text colors and then organize only those items into a chart.
VBA To Convert Conditional Formatting To Fixed Formatting?
Jul 5, 2013Any VBA that I can put into a macro that will convert conditional formatting into fixed formatting..? So when the cell contents/formulas are deleted the formatting remains. Assume that the range I want to convert is A1:D200...
View 9 Replies View RelatedToo Much Formatting - Save Error "Could Not Save All The Data And Formatting"
Jun 5, 2008Does anyone have a workaround for the following error "Excel Could Not Save All the Data and Formatting" Error Message (http://support.microsoft.com/kb/215783). I am applying validation to many, many cells
View 4 Replies View RelatedVBA For Formatting In The Same Row
Sep 16, 2008I wasn't sure how to properly title this post. I actually have a couple of questions. The main one is on how I can code my VBA so that for the range A11:N80 I have specific conditional formatting code, and then for O11:AB80 I have different conditional formatting code, and so on for 12 sections.
The conditional formatting reads column L (in the first section) for one of 6 different words and depending on which word is read, it fills the row from A to N with the corresponding color. I have this working, but I do not know how to do the same with with section O11:AB80 and so on. The actual formatting within each section will be the same but the data is different so different lines will be filled in. Here's my code so far:
New Row Formatting
Jan 12, 2010I have a userform set up to create a new row on a worksheet and enter data that was filled out on the work sheet. Some of the data comes from text boxes which put in name, rate, division, received date, and loss date. The other info is taken from checkboxes and designed to put either an X or N/A, or just leave a column blank. Basically, what I want to do is figure out, when I make a new row, how to format that row to have borders around each cell, make columns 6-29 bold, and the cells in columns 6-29 colored with a gray background. If you need a dummy worksheet to better describe what I'm looking for, let me know. I haven't made one up yet.
View 4 Replies View RelatedFormatting Zero To -
Apr 20, 2009How do I keep the number format to general and change 0 (zero) to "-"
I dont require a formula soution but rather through formatting cells.
Formatting
Dec 7, 2009The following image shows the problem I am having with my formatting in excel. There's nothing in the cell featured to make the cell length longer, but the combo box still does what is shown in the image. any idea how to prevent this? it looks messy for an end user!
View 9 Replies View RelatedCPU To CPU Formatting
Jan 13, 2010I am using Excel 2007.
I've created a database template that my partner and I will have on our laptops to use in the field. It is viewed in Page Layout.
When it is on my laptop, I show 30 rows on page one of the first worksheet. But on my partner's laptop it shows 29 rows. This messes up some of the formatting.
It isn't because he has changed anything. I sent my copy via email and a flash drive and opened it myself, and the problem still exists.
Hidden Formatting
Aug 8, 2008I am using the VLookup function with two seperate sheets. The first sheet is what I have created. The second sheet is one that was given to me.
I know how to build the format as I have done it numerous times in the past. This one only works if I copy the data into notepad, then copy it back into excel. Then it will work. I have looked at the formatting and I cannot see any differences.
way to get it to work without the notepad part?
Lost Formatting
Nov 9, 2008I have a workbook that is used by others and has been working reasonably well for several years. The users are youngsters who tend to play with it when a bit bored but I usually manage to put things right. They seem to have done something special this time.
The formatting for dates, time and money has gone and I cannot correct it. I have tried the usual formatting of cells, painting formats from other sheets, copying and pasting formats all to no avail. The whole sheet is effected so that new entries appear the same way although the correct format appears in the formula bar.
I don't know if this is relevant but the sheet relies on VBA form inputs. The code is password protected and only I know the password.
The PC is not connect to the internet or a network so I have ruled out a virus. (As far as I know, no floppies or USB sticks have been used on it either.)
Conditional Formatting - More Than 3
Dec 9, 2008In a column, there are 4 option for each cell -
"PAYMENT DUE"
"PAID"
"UNDERPAID BY..."
'OVERPAID BY..."
These are filled in by a formula
I would like to make them 4 different colours but excel only allows 3 options
Text Formatting
Jan 22, 2009I have a large list composed of three columns, First name, Last name, and Email address. For the most part names and emails match up perfectly but there are an unknown number of names that do not match their email address. Here’s the hard part, email addresses are in different formats for example:
some are firstname.lastname@somewhere.com but others can be lastname.firstname@somewhere.com or some email addresses are first name initial then full last name with no dot separator @somewhere.com and even turned around like Last name initial then first name. For the most part this is the only four ways the emails are configured but all email addresses have some variation of last and first name in them.
How can I find the number of email addresses that do not match their names?
I warned you that it was hard.
If Then Or Conditional Formatting??
Mar 5, 2009I have a hard time when it comes to "If then" statements and conditional formatting. I have some data that I am collecting and entering into a spreadsheet for a couple different companies. Once I receive paperwork from those companies for the data collected I mark the data with a blue colored text. I would like to have a second sheet that generates what companies have not sent me their paperwork. "If the data is black text, then generate <name of company> on second sheet." The list is small right now, but as the project continues it will grow very large and it will become difficult to track. I will attach a copy of the spreadsheet for you to see the situation. I would like to learn how to do these types of formulas, is there a tutorial geared towards these types of situations?
View 2 Replies View RelatedData Formatting..
Apr 26, 2009i have an application that can export tables to Excel. But in Excel, the data is only recognized as text, and not as or numbers. A typical column looks like this:
$300,40
$500,23
($350,00)
etc.
An amount in brackets signify a negative amount. Is there an easy way how i can convert this cells into numbers i can work with in excel? I have a similar problem with dates, times and cells with both date and time in them.
Vlookup Formatting
May 15, 2009If i have a table like the one below.
A1 B1
1 Snot
0 Cheese
0 Pie
0 Bacon
1 Tree
0 Breakfast
1 Hair
0 Tidy
1 Box
How do i use vlookup to give me list like below
A1 B1
1 Snot
1 Tree
1 Hair
1 Box
Points Formatting
Aug 20, 2009I am doing a golf predictor where I am using all 3 sheets in a spredsheet.
In sheet 1 I have the teams of players my friends have picked.
Sheet 2 I have the prgressive scores for each team done on a weekly basis.
Sheet 3 I have the names of 56 golfers and the points each can win for finishing anywhere between 1st and 22nd in a competition.
What I would like to know is there anyway I can replace the values 1st to 22nd with points (i.e., 1st = 400 2nd = 340 3rd =310 and so on down to 22nd) also is there a way I can transfer values between sheets.
Combo Box Formatting
Sep 22, 2009-To have the text alignment as centered; and
-Have a shading in it (as per the row)
I have attached a spreadsheet so you know what I mean.
For instance the row in which the combo exists, is shaded blue, is there a way to make the box the same shading too?
Date Formatting?
Sep 25, 2009In cell c23 i am trying to return a date which is in cell h4 and then the word "to" and then another date in cell l4
the formula i have is
Text Formatting...?
Oct 1, 2009I'm looking to see if I could use any sort of formula to have 1 number appear Red and another number appear Black all in one cell
In 1 Cell: 80 (75-95)
I'm looking to use this formula, where I'd like my A1 to be Red
=A1 & " " & A2
Conditional Formatting With Vba...?
Dec 23, 2009I seem to have a problem using conditional formatting with Vba in Excel 2003
When I run -
Date Formatting...
Feb 11, 2010i m having problems with a simple formula but i cant get it right
in cell a1
Tab Delimited Formatting
Mar 1, 2008i have a tab delimited file that desperately needs cleaning up.
i would like this:
word1 def1
word1 def2
word1 def3
word2 def1a
word2 def1b
to look like this
word1 def1, def2, def3.
word2 def1, def2.
my problem is this dictionary goes on and on, and i would just like a simple way to find these duplicate entries and consolidate them into the form i showed above
Formatting Until A Condition Is Met
Jan 26, 2009I have the following code which prints the number of time steps required and displays it as t0, t1, t2 etc how can I make all the numbers subscript? i.e until the number of time steps = the total time.
View 2 Replies View RelatedCell Formatting
Apr 29, 2009I have been trying, without any luck to find a way of doing the following: If I enter a figure for example of 1.23, I would like a macro to then evaluate the cell and format it to two decimal places. But if the enter figure has only 1 decimal, to leave it at the standard 1 decimal format. I would like to be able to incorporate it in the following
View 4 Replies View RelatedFormatting Date In VB..?
Jul 5, 2009I found this really great vb code for my spreadsheet to be updated with the current date whenever the range is updated. I modified it a bit to include a bit more in the cell A1. what I can't work out is how to format the date so that it only shows me the date as 06/07/2009. It currently returns the date and time.
View 2 Replies View RelatedText Formatting With VBA
Jul 14, 2009I have text in a cell like this:
MINOR Ø1.2314-1.2414 ([-XX-] "Minor" Ø1.23640 +/-.00500, SF1015-16)
The cell width is 35.71", this causes the text above to wrap. The part I am having trouble with is getting the text to be readable without portions of the text being split, such as:
MINOR Ø1.2314-1.2414 ([-XX-] "Minor" Ø1.23640 +/-.
.00500, SF1015-16)
Ultimately for readability I would like the text to read like this:
MINOR Ø1.2314-1.2414
([-XX-] "Minor" Ø1.23640 +/-.00500, SF1015-16)
Within the same cell.
The second string will always have a " (" at its beginning, a "space" and a "left bracket". Of course the string of text will always vary in length and some times only one character wraps or a majority of characters wrap.