conditional formula

  1. T

    Adjust worksheet placement based on dropdown selected

    I have created validated dropdown, which in turn I have used for conditional formatting to highlight specific consecutive rows based on the dropdown.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Is it possible for the worksheet to be...
  2. A

    2 conditions and one wildcard in a phrase

    "I want to find 'Mozilla' in the phrase in column 'A' and 'Phone' in column 'B': A B BW System 20042010 Phone Screen no bright on laptop Phone Pop up screen in Mozilla...
  3. T

    Conditional Sum Formula

    Looking for help with another conditional sum formula. When either AL6 or AM6 have a value that is not zero or null, I want the formula to sum AJ6, AL6, AM6. When both AL6 and AM6 have a null/zero value, I want the formula to return a value of "-". Desired results AJ6: Original value = 500...
  4. J

    Too many If then conditions

    I am trying to use a formula where I have about 10 different scenarios for the checking whether a cell in column A contains certain text; based on which I want to type a certain text in the corresponding cell in column B Is there a simple way rather than using the =IF formula cause currently my...
  5. M

    Advanced Conditional Formatting

    Hi all, I have a rather tricky conditional formatting problem I need help with. Im creating a milestone chart in MS Excel (as opposed to Project). The dates are listed along the top of the sheet and are done so according to week i.e. for Febuary 09 there are the cells for dates: 02-02...
  6. B

    Conditional Hiding of a column

    I am trying to hide columns if their value (in cells BR3:CB3) = 0. If the cell = 0, I would like for the entire column to be hidden. I think I could build an if statement for each individual cell, but maybe there is a way to do a "do while" or "for every"...but I am not as familiar with...
  7. A

    Conditional Formatting Formula

    I have a spreadsheet containing dates, I need to shade the cells with dates that are 'in the past' (dates are, once again, taken from another worksheet using VLOOKUP), i know this is done using conditional formatting, more than likely 'formula is' but can't quite work it out. I manually enter...
  8. S

    IF formula help

    Hi All, I am trying to perform the following calculation If any cell in B=555ABC then add value in H to G14 Your assistance would be greatly appreciated as this seams simple but I cannot for the life of me get the formula caorrect
  9. D

    Please help with condition and HYPERLINK

    Hi, I am trying to come up with formula to use HYPERLINK function. IF A2="YES" THEN B2=HYPERLINK("\\c:temp\test.file") I need cell B2 to show hyperlink based on the value of cell A2 (YES/NO). Is this possible? Thank you, djanu
  10. M

    Conditional IF Formular, pls help me.....!!!

    Hell everyone,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have an excel table that I need to Calculate the commission from Jan – Dec which is to based on the following conditions;<o:p></o:p> Under the commission column for each row I need too calc...
  11. D

    How do I make a formula that is conditional

    I am creating an excel file for employees to enter their time. I want to have a formula set up that will automatically total the number of hours spent on specific project categories. For example, cell C6 is a drop down list having multiple categories to choose from. Cell D6 is the total number...
  12. Maverick99

    Formula: If then Change, If not Leave Alone

    I would like to apply a formula to a 70,000 row column that will allow me to change a cell's value if a particular condition exists, and if it doesn't then leave the current value alone. Example: G5 Rev-Budget 100 If ((G5 = Rev-Actual),ABS(G5),Leave Value Alone) G6 Rev-Actual -120 If ((G6 =...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top