Turning The Row Gold

Jun 13, 2006

I have a sales and prospects spreadsheet. It has information in columns A to O. The last 3 columns M, N and O, require a 'Y' for Yes or 'N' for No entry. If entering N, the background colour of the cell turns grey using conditional formatting, and if entering Y the background colour of the cell turns Gold using conditional formatting. Column O is headed 'Sold', so that column is onviously the final Y. Upon entering Y in column O, ie the sale is made, I's like it that the whole row, so all cells of that row in columns A to and including O turn gold to easily visually differentiate done deals from prospects.

Also what would be cool is if when a deal is done, it not only turns the whole row gold, but moves the row to the top of the sheet, so by dividing done deals from prospects, that is utopia at this stage though, more important is turning the row gold upon a Y entry in column O.

View 9 Replies


ADVERTISEMENT

Warcraft 'gold' Number Format, Or G00.00.00

Nov 24, 2006

I am trying to build some spreadsheets that handle exported data from the 'auction house' of the well known warcraft game.

I have exported data, but currency is exported in a concatinated string such as 463200.

In that example there would be 46 gold, 32 Silver and 00 copper. If the string was 63200 there would be 6 Gold, 32 Silver and 00 copper.

As I have about 18 different columns containing currency data I am trying to get excel to handle this format, however I cant seem to find a number format that will work with what is essentially two seperators in the number. Not only do I wish to display gold silver and copper in different colours, I wish to be able to perform calculations on the values.

Thus 463226 + 378475 should equal 841701.

View 9 Replies View Related

2.5 Turning Into 02.may

Jul 8, 2008

I have this annoying problem with my excel 2003. And i have no clue at all how to solve this.

Each time i write 2.5 it turns into 02.may. Does any one know how i can fix this?

View 14 Replies View Related

Autofill - Turning Off?

Oct 22, 2013

I fill out this form everyday and sometimes need to type "S" and every time it fills in "Sampling Rate #1" because that's what it says in the same column higher up. Is it possible to turn this off somehow?

View 3 Replies View Related

Turning On A Checkbox

Apr 13, 2008

I want to turn on (tick) a check box from within a macro.

View 9 Replies View Related

Turning Off The Clipboard Sound

Dec 12, 2007

I recently installed Office 2002 onto a new computer and found that whenever I drag-and-drop any amount of data from one cell to another, a loud obnoxious noise plays when I release the drag-and-drop data.

I was using the same version of Office on my old computer and did not have this problem.

I'm guessing it's a clipboard issue, since when I open the Excel clipboard (where I currently have all options as unchecked) and copy something so it is captured there, the same noise plays.

I already have turned off Windows sounds via the Control Panel and have no clue how to turn off this sound.

View 12 Replies View Related

Turning Decimals Into Millions

Feb 13, 2014

I'm going through financial statements and I would like to be able to run full blown analysis on them. Most public financial reports are written so that a lot of zero's do not take up the useful space. As such (and there is a ton of this solution out there I've found), many people want to take $1,500,000,000 and turn it into 1.5M

I however, do not. I want to convert it backwards. So when something says 5.19 I would like to format it in such a way that it will read (and I can run calculations against it) as 5,190,000,000 (there are no alpha characters, there are instances where there will be negative numbers). Then I could copy this to the 17 different financial statements I've already got rock'n rolling in Excel right now.

View 4 Replies View Related

Turning Off Timer Macro?

Mar 18, 2014

I have the Macro

[Code]....

That starts a timer macro (Recalc) in my excel sheet when the workbook is opened, my issue is that when the work book closes it continues to run.

Will the following macro fix this problem, or is there some command like Workbook_Open() but for closing?

[Code] ....

View 1 Replies View Related

Turning On/Off Picture Refresh

Sep 23, 2009

I have a workbook that has many Pictures created with the Camera command. I have found that VBA macros in any workbook open at the same time as the one with Pictures run very slowly. Is there a way of temporarily turning off the Picture Refresh within the VBA in the same way as you can turn off automatic formula updating.

Keith

View 7 Replies View Related

Turning Data Into Matrix?

Oct 18, 2011

I have 2 lines with pairs and 3rd with corresponding values, nee to construct a matrix out of it with formulas

Example
Need to turn

AAABBDBCDCDC0.30.20.130.550.840.43

into

ABCDA11-0.31-0.21-0.13B0.311-0.551-0.84C0.20.5510.43D0.130.841-0.431

So the one that stands above in the initial file goes to the top line in the matrix. 2 line -> column in matrix. In case there is no match need to seek reverse in 1,2 and reflect as 1-VALUE in the matrix

View 3 Replies View Related

Turning Columns To Rows?

May 14, 2012

Current Tabel:

Sheet1
ABCDEFGHIJKLMNO1EVENT NAME DATEGROUP / LOGOEVENT LOCATION DELIVERY DATEITEMCountMUGSBLK T'SPADSGREY T'S DRIVEBLK PENSCOINSBLK POLOS35Inter.05/01/12ABCShip to ABC04/25/12 60 45 32

This is what I want to do with it:

Sheet1
ABCDEFG1EVENT NAME DATEGROUP / LOGOEVENT LOCATION DELIVERY DATEITEMCount35Inter.05/01/12ABCShip to ABC04/25/12MUGS6036Inter.05/01/12ABCShip to ABC04/25/12BLK T'S 37Inter.05/01/12ABCShip to ABC04/25/12PADS4538Inter.05/01/12ABCShip to ABC04/25/12 DRIVE3239Inter.05/01/12ABCShip to ABC04/25/12GREY T'S 40Inter.05/01/12ABCShip to ABC04/25/12BLK PENS 41Inter.05/01/12ABCShip to ABC04/25/12COINS 42Inter.05/01/12ABCShip to ABC04/25/12BLK POLOS

View 9 Replies View Related

Stop 100% From Turning Into 1000%?

Apr 1, 2014

How to stop my 100% from changing to 1000% after it pastes?

Here's the pc of code that is performing the copy/paste from one sheet to another sheet within the same workbook..

Code:

With Sheets("BOM Worksheet").Range("C" & nr)

.Value = c.Offset(, -16).Value
.Font.FontStyle = "Bold"
.Font.Color = RGB(186, 85, 211)

End With

View 6 Replies View Related

Dates - Cells Turning Red

Aug 28, 2008

I have a column of dates and have been asked to turn a cell next to it green, orange or red but I don't think this can be done?

Otherwise is there a way to turn the background of the cell a different colour, am sure there is?

What I need is if for example the date in the column is 01.08.08 then up until 7 days I want it to turn green, between 8-10 days I want it to go orange and over 10 days it needs to go red. Is this possible?

View 9 Replies View Related

Turning A List Into A Spreadsheet

Dec 17, 2008

I need to turn a list of information into a true spreadsheet, how do I look up the information to fall under the appropriate headers?

Example:
Instead of...
Invoice # 000
Date Of invoice 01/01/08
Name: Smith/Steve
Invoice # 001
Date of invoice 01/01/08
Name: Smith/Sally

I need...
Invoice Date of invoice Name
000 01/01/08 Smith/Steve
001 01/01/08 Smith/Sally

View 9 Replies View Related

Turning Dates Into Weeks

Jan 14, 2009

"Decision Date". It is a numerical date (ex: 1/5/09 indicating January 5th 2009).

I need to turn that date into the week that it falls into within a particular quarter of a year.
1/5/09 would be Week 2 (it is in the second week of January, and 2nd week of the quarter)
2/3/09 would be week 6 (6th week of the quarter).

And then I need the formula to start over once each quarter restarts... for example, April 1st would be week 1 (1st week of the second quarter).

View 9 Replies View Related

Turning On Relative Cells

Feb 3, 2010

I have this formula:
=IF('2010'!R10C2="y",'2010'!R10C3,"")

And I want to be able to drag it down and have the cells update, but all it does is keep the same values.

Is there something I need to turn on or off.

View 9 Replies View Related

Turning Words Into Numbers

May 30, 2006

i would like to know how to turn the word beside into numbers, ie if b=2,e=5,s=60,i=10,d=4,

also can this word be in the one cell or would it have to be entered separately, ie one letter per cell??

View 9 Replies View Related

Turning On Comments On Worksheet

Apr 23, 2007

how to turn on the Comment Indicator through VBA? The code equivalent of setting Tools / Options / View and then selecting the Comment Indicator Only option.

View 2 Replies View Related

Turning Name Into Email Address As A Rule

May 20, 2014

Is it possible to create a rule that every time I type my name, for my e-mail address to pop up in excel instead?

For example, if I type "purple1686", I want "12purpleexample@domain.com" to show up as a hyperlink to my default e-mail program.

I am also curious if I was to write "my website" is it possible to make it a hyperlink to "www.purple1686example.com"?

Those two first may be easy to answer, so here is the challenging part for me:

Can I make that happen as a rule on every spreadsheet I open?

I don't know if I should make a template, or use a formula? The ideal scenario would be if there was a way to do it through conditional formatting.

I have used conditional formatting to change the color of a word every single time I open a new template and paste the words into it, or even by typing them out.

View 1 Replies View Related

Turning Monthly Data Into Daily?

Jul 26, 2014

Is it possible to turn monthly data into daily? Repeating the same data for four sets of five working days to turn a CPI monthly inflation index into daily data, to turn example 1 into example 2.

Example 1.

DATEVALUE
2008-01-01 212.174
2008-02-01 212.687
2008-03-01 213.448
2008-04-01 213.942
2008-05-01 215.208

Example 2:

2008-01-01 212.174
2008-01-02 212.174
2008-01-03 212.174
2008-01-04 212.174

View 3 Replies View Related

Turning Formula Cells Into Numbers

Dec 11, 2008

I populated an XL sheet from another one using a formula. However, in order to use my new sheet I need all the cells to be numbers and not formulas. Is there a way to turn all the formulas into numbers, leaving behind just the numerical value ? Basically like pasting only values, only without having have to paste them somewhere else.

View 2 Replies View Related

If Conditional Formatting (turning Those Cells Off)

Jun 9, 2009

what i want to do is say:

If A1="" then color B1 and C1 black, basically turning those cells off

View 2 Replies View Related

Turning Locations In Cells Into Values

Aug 4, 2009

I am looking to do find the latest date in a list of dates but have several problems:
1) The dates are all in one column on worksheet 1, but are sourced from other worksheets. So even though it looks like '8/7/09', the value of the cell is 'Worksheet2!B4'. This is making the MAX function not work

2) How to deal with the blank cells in the MAX function?

View 12 Replies View Related

Excel / Word Turning Months Into 00

Feb 5, 2013

I am exporting data in from a different program (Results Plus), into a Word 2010 mail merged document with a header file attached. The header file is an Excel table of my merged fields. I have gone through all the steps to make sure it's not that software. Now I still cannot figure out why all of my months are turning into "00" in a Word mail merge. I have tried @ "MM/dd/yyyy" and it end ups flipping the month and day around.

For example: it should be January 8, 2013. It shows up originally in my document as "00 8, 2013". When I add the [switch] @ "MM/dd/yyyy" it shows up as, "08/01/2013". When I tested it out and put "MMMM/dd/yyyy" it shows up as August 1, 2013 instead of what it should be, January 8, 2013.

I have checked my default language (English US).

How do I stop this?

View 8 Replies View Related

Turning Off Auto Spell Correction

Jul 8, 2013

I am trying to enter the last name "Teh" in a cell. How do I turn off auto spell correction that turns "Teh" into "The"?

View 3 Replies View Related

Turning Range Of Data Into Table

Jan 10, 2012

Is it possible to turn a range of data into a more detailed table.

for instance -

the input data would be something like

1 - 3 @ 50%

4 - 6 @20%

8-10 @70%

the output i'm looking for would be a table like below

1 - 50%
2 - 50%
3 - 50%
4 - 20%
5 - 20%
6 - 20%
7 - 0
8 - 70%
9 - 70%
10 - 70%

View 3 Replies View Related

Toggle Switch For Turning Protection On Or Off

Feb 6, 2012

How can I do the following:

I need a toggle switch that switches between protecting and unprotecting the worksheet.

It should display the text 'Entry Mode' when the sheet is protected and 'Filter Mode' when the sheet is unprotected.

View 3 Replies View Related

Excel 2007 :: Turning Formulas On And Off

Mar 14, 2012

Background info: I have developed a Hired Equipment Time Sheet with numerous formulas to auto populate and calculate various cells to minimize user impute requirements.

Can cell formulas be toggled on and off to allow manual impute of data rather than the formula automatically populating information in the cell if the need arises? If so, can this be done via a drop down pick? Also can or will the formula still be protected?

View 2 Replies View Related

Turning Grade % Into Letter Grades

Aug 11, 2007

creating a function to turn a percent (0-100) into a letter grade, I am creating a gradebook spreadsheet.

I think VLOOKUP is the way to go here, but I do not understand vlookup at all no matter how many times I try to look at demos or read how-tos.

I created two columns, one with what the grade entails (93-100 , 90-93 and so on) and the next column has A, A-, etc. But I can't get vlookup to work, any suggestions? I am pretty noob when it comes to excel.

View 9 Replies View Related

Taking Number And Turning It Into Time

Feb 20, 2009

I have created a simple spreadsheet to keep track of work hours. I simply enter in each days hours and then I get a total. I have each cell formatted for time (hh:mm). However it is annoying to have to type in the colon for each days time.

Is there a way I can just type in the three digits '9,3,0' into the cell and have it come out as '9:30'?

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved