Office Software Forum

Ask a question
Search
Close
Results 5901 - 5950 of about 16,600
  • highlight cell if the finish date of a task is less than x days Closed

    Please could somebody help me with this problem. I have a spreadsheet and i would like make some cells to go yellow if the finish date of a paticular...

    v022695 | Excel | Latest reply: venkat1926 Apr 10, 2014
    1 reply
  • Function or Macro to read cells in a column and color them Closed

    Hi Guys, I need to write a VBA macro or a formula/function, which actually reads the value and color of cells in column and in turn color other cel...

    jain.prashant31 | Excel | Latest reply: venkat1926 Apr 10, 2014
    7 replies
  • how to calculate number of days between dates Closed

    Please I need ideas of how to get the number of days between to sets of dates in an excel column. The preceeding dates all the way to the end of the l...

    VickyAliri | Excel | Latest reply: ac3mark Apr 9, 2014
    4 replies
  • outlook won't open word attachments Closed

    Hello, I have Microsoft office 2003 and Windows XP home. When I try to open an email attachment that is a word document Outlook crashes. This happens...

    cmg | Word | Latest reply: whiggins Apr 9, 2014
    19 replies
  • VB code to email at File Save is nnot auto-running Closed

    Hello, all, I hate to rehash this old message, but since Microsoft never stops messing with things, I suppose threads like this will never die. Ma...

    geelsu | Excel | Latest reply: geelsu Apr 9, 2014
    1 reply
  • VB macros extract data containing ".CF from a particular cell Closed

    Hi, i would like to know how to extract data containing ".CF from a particular cell and to a different workbook with the entire values of the row.....

    Rohit47 | Excel | Latest reply: Rohit47 Apr 9, 2014
    0 replies
  • comparing 2 excel with diff length Closed

    I have two columns of numbers A B 123 223Abc 223 334ssd 334 368def 456 456def i want to compare n...

    sabrinadwitch | Excel | Latest reply: sabrinadwitch Apr 9, 2014
    0 replies
  • If date range, then % commission. Closed

    I am trying to create a formula that will look at a group of rows and calculate a percentage of a particular date range of money. The rows have a dat...

    ace350 | Excel | Latest reply: ac3mark Apr 8, 2014
    5 replies
  • formula that allows it to calculate the sum of Closed

    Hi ! I'm looking to create a formula that allows it to calculate the sum of.. =SUM(D3*E3+D4*E4+D5*E5+D6*E6)... but it needs to do this from ro...

    RivkaJ | Excel | Latest reply: RivkaJ Apr 8, 2014
    2 replies
  • determine percentage via formula Solved/Closed

    Hello, can anyone help me determine a formula that will give me a percentage? If N11 is 2500 and I11 is 84, I need a formula that will help me determi...

    kaiwalls04 | Excel | Latest reply: kaiwalls04 Apr 8, 2014
    3 replies
  • VBA - insert pictures into excel Closed

    Hi there, I am trying to write code to insert pictures based on the file name in column B4, with the picture to be displayed in Column C4. This con...

    jlljacintado... | Excel | Latest reply: TrowaD Apr 8, 2014
    1 reply
  • Help Creating Macro Closed

    Hello, I hope someone can help me since I don't have the knowledge to do it. I'm trying to build a macro that check the value in an excel cell ...

    joaopedr1 | Excel | Latest reply: TrowaD Apr 8, 2014
    3 replies
  • Copy data from two columns to third columns on a condition Closed

    Column A1 containing the current day =today() From B4:B33 the dates from the beginning of the month till end of the month From C4:C33 the first ...

    tarek-kamel | Excel | Latest reply: TrowaD Apr 8, 2014
    1 reply
  • How to calculate percentage of savings Closed

    Sir, Im going to invest in a gold saving scheme .12 months scheme 100 per month at last they are giving 50 as free .how to calculate the percentage...

    sunilantonz | Excel | Latest reply: TrowaD Apr 8, 2014
    1 reply
  • Excel invoice w/data from spreadsheet 1 and update spreadsheet 3 Closed

    Good morning experts, I sincerely hope that you can help me out. Currently, we use an Excel template to write invoices (a modified Excel 2010 ...

    LearningLife... | Excel | Latest reply: TrowaD Apr 8, 2014
    1 reply
  • How to calculate the average of a range day by day? Closed

    Hi all, How to calculate the average of a range day by day? A is the column for the day, and the average should go at the top of each day. I've done ...

    jutulu | Excel | Latest reply: TrowaD Apr 8, 2014
    1 reply
  • Change the rows font colour based on one cell Closed

    Hi I would like to create a rule to change the whole rows font when something is put into any cell in column V - who do I do this?

    RDyman | Excel | Latest reply: Mazzaropi Apr 8, 2014
    1 reply
  • two values to find on the same cell Solved/Closed

    Hi, Can the below be shorten up? It's basically to count if "dr" or "ba" are in cell E2180; =IF(ISNUMBER(SEARCH("(dr)",E2180)),"1",IF(ISNUMBER(SEA...

    jutulu | Excel | Latest reply: jutulu Apr 7, 2014
    2 replies
  • date convert in text Closed

    how to convert date value into text value.so, what we can convert that value. For e.g. 2/2/2013 than convert into second February two thousand thirte...

    jaygohel | Excel | Latest reply: TrowaD Apr 7, 2014
    1 reply
  • where can I get MS Office publisher for free Solved/Closed

    Hi, any body can help me, where I can to get MS office publisher for free?

    spectator | Open Office | Latest reply: spectator Apr 7, 2014
    2 replies
  • Help- how to add prefix on Spreadsheet Closed

    Hello, I am pretty new to using spreadsheets. I have a large spreadsheet with part numbers and I want to add a FJ prefix at the start of the part num...

    ChilliRed | Excel | Latest reply: ChilliRed Apr 7, 2014
    4 replies
  • convert number to text Closed

    Hello, i wanna ask how to convert number to text in MS, since i found only in English like {=123\*cardtext}, but i need your help for arabic tex...

    mohamedchihime | Word | Latest reply: mohamedchihime Apr 7, 2014
    0 replies
  • convert numbers to arabic words Closed

    hi , can you help me to find a way to convert numbers to arabic words, since i use the ctrl F9 to convert to English , and asking if you can help me t...

    mohamedchihime | Excel | Latest reply: mohamedchihime Apr 6, 2014
    0 replies
  • problem in renaming a ms office word 2007 document Closed

    Hello, when i tried to RENAME THE file name of ms office word 2oo7, a dialogue appears that if you tried to change file name extension it may bec...

    p.v. krishna | Word | Latest reply: Ambucias Apr 5, 2014
    1 reply
  • problem in renaming the ms office 2007 word document Closed

    When I tried to rename the ms office 2007 word document, a dialogue box appears that if you change the file name extension, it may become unusable, ar...

    pvkrishna | Word | Latest reply: xpcman Apr 5, 2014
    1 reply
  • Macro to delete row after certain condition found Solved/Closed

    Hello, I am an Excel newbie; I am trying to write an Excel macro that will search a certain column to find a blank value. It would then delete the...

    wendelly | Excel | Latest reply: wendelly Apr 4, 2014
    6 replies
  • issue with date formatting Closed

    Hello, For some reason, when I insert date formatting into Excel on my work computer, the numbers that appear in the spreadsheet are completely diffe...

    HDW | Excel | Latest reply: ac3mark Apr 4, 2014
    1 reply
  • if then (text or no text) Solved/Closed

    Hi, I hope someone can help me with this. I would like to create a formula that says this: if a certain cell contains ANY text, then write "6.2"...

    hikkup | Excel | Latest reply: hikkup Apr 4, 2014
    4 replies
  • Microsoft office 2007 excel files are not shown Closed

    Microsoft office 2007 excel files are not shown in microsoft office 2003 & 2010. what can i do to see my excel files again.

    pettertom | Excel | Latest reply: dluv28u Apr 4, 2014
    1 reply
  • Excel - insert data to many lines based on a set of ID numbers Closed

    Does anyone know what type of macro could help with my problem. I have a spreadsheet. Column A has an ID (example Test and Apple). Each ID has a se...

    mvillamarin12 | Excel | Latest reply: mvillamarin12 Apr 3, 2014
    2 replies
  • Add IF Excel 2013 formula to sum all those items with code Closed

    Hello, I am Dr Kunvar Harsh from India I wanted to know if there is any way I can put formula to sum all those items with code e.g E C, H C, K ...

    Kunvarharsh | Excel | Latest reply: ac3mark Apr 3, 2014
    1 reply
  • CHANGE CELL BASED ON TWO OTHER CELLS' VALUES AS COORDENATES Closed

    Hello, I am new at this website and in vba programming and I am looking for some assistance with my vba code. I'm trying to right a code that makes ...

    dbsimoes92 | Excel | Latest reply: dbsimoes92 Apr 3, 2014
    2 replies
  • Excel vba that will change color according to another cell's col Closed

    Hi I am trying to change a cell color according to the color of another cell, tried diffarent ways to do this but failing could someone help please...

    jcinum | Excel | Latest reply: TrowaD Apr 3, 2014
    1 reply
  • connect two worksheets together Solved/Closed

    Hello, I am trying to connect two worksheets together. If text found in one cell in sheet1, make the same cell on sheet2 different color. Ther...

    rookie | Excel | Latest reply: rookie Apr 3, 2014
    2 replies
  • Conditional Formatting: Highlight cells based on two values Solved/Closed

    Hello, I have a merged cell (C5-N5) that I want to change the fill color, based on the combined input of two cell values. I'll just call it "C5" f...

    Plastic_Cup_... | Excel | Latest reply: Plastic_Cup_of_Stars Apr 2, 2014
    2 replies
  • True/False Statment Using Four Values Closed

    Hi everyone! I'm working on a spreadsheet that will drastically reduce the time our staff have to do paperwork, and I'm oh so close but I can't get...

    iwnixon | Excel | Latest reply: ac3mark Apr 2, 2014
    1 reply
  • Auto populate sheets based on main spreadsheet Closed

    Hello, I am having some trouble creating a building floor directory. I would like to have one main spreadsheet with everyone's name, title, departme...

    amy2876 | Excel | Latest reply: amy2876 Apr 2, 2014
    8 replies
  • Code of copy paste data Closed

    Hi all of you I have my data spreaded from A2 to K2 and the huge long block of data. I wanted a solution like this. Consider The first block of ...

    SPPS | Excel | Latest reply: SPPS Apr 2, 2014
    0 replies
  • VBA Macro Conditional Formatting Closed

    I need to find out how to write a macro that includes Conditional Formatting. =if(and(Column A has the word "Dial")and(Column F has the word "Booke...

    slohman | Excel | Latest reply: slohman Apr 2, 2014
    3 replies
  • False value, other than the weekly total Closed

    =IF(C1716="","",IF(COUNTIF(C$2:C1716,C1716)=1,COUNTIFS($H$2:$H$11999,1,$C$2:$C$11999,$C1716)=1,"")) I enter the above formula to calculate the tota...

    jutulu | Excel | Latest reply: jutulu Apr 1, 2014
    2 replies
  • Hacked e-mail account Solved/Closed

    how to retrieve my hacked hotmail account. I tried 3 attempts by using the Microsoft forms to reset my password but it failed. Missing some security ...

    leolyster | Outlook | Latest reply: Ambucias Apr 1, 2014
    2 replies
  • FALSE statement Closed

    Hi, The below gives me a FALSE statement. I took off the second "" at the end but makes no difference: =IF(OR(AQ2246=0,AY2246=0),"",IF(COUNTIF(AJ$...

    jutulu | Excel | Latest reply: ac3mark Apr 1, 2014
    1 reply
  • CHANGE CELL VALUE BASED ON TWO OTHER CELLS' VALUES Closed

    Hi, i'm trying to right a code that makes a change and then try to applies it on other tab by taking the value of one cell that returns the number of...

    dbsimoes92 | Excel | Latest reply: dbsimoes92 Apr 1, 2014
    0 replies
  • Large size PDF file printing Closed

    Hello, Dear All, I am have trouble shooting with printing documents I have a file PDF with 30 mb when i printing it to Canon printer, the status ...

    VeasnaYim | PDF | Latest reply: xpcman Apr 1, 2014
    1 reply
  • date format Closed

    Hello when i work in excel format 2007 like dd/mm/yyyy when i import the data some date are convert wrongly like 5/3/2014 (March 5th 2014) May ...

    uru | Excel | Latest reply: iamdinesh Apr 1, 2014
    1 reply
  • i cant open excel file Closed

    Hello, i cant open excel file. message :there was a problem sending the command to the program. Configuration: Windows 7 / Firefox 28.0

    binoy | Excel | Latest reply: binoy Apr 1, 2014
    0 replies
  • Selecting Cell based on a criteria and copy selected row Closed

    Hello, I am working on VBA for the following Selecting cell based on criteria and the copying the selected row to another sheet. Then deletin...

    Debs269 | Excel | Latest reply: Debs269 Apr 1, 2014
    6 replies
  • fonts in excel Closed

    I want to reply to the comments in cells in a color which have alrady been typed in another color. Ex: if i get a comment in red color , i want my rep...

    Komal88 | Excel | Latest reply: TrowaD Mar 31, 2014
    1 reply
  • Maximum and minimum values of a column Closed

    Hi, I have a rather large database of experimental values and rather that giving the average of a particular set, I would like to give a range as it ...

    losullivan | Excel | Latest reply: losullivan Mar 31, 2014
    0 replies
  • Lining up group of cell values in Excel 2007 Solved/Closed

    Hi I have two group of cells D6 to D8 and other G12 to G15 Need a code with two conditions that can line up the details of the mentioned cells in ...

    PPattni | Excel | Latest reply: TrowaD Mar 31, 2014
    7 replies