condiational

  1. M

    "IF" "Index-Match"

    I have a conditional index match formula meant to return the price for items if the price is missing. Column A represents the actual number of items, B represents the price of that item and C represents the time at which the time was that price. Column F-G represent the standard prices for the...
  2. H

    Multiple Conditional IF with the ability activate/deactivate a condition

    Excel 2007 How do I make a multiple conditional formula have the ability to active/deactivate a certain condition dynamically. The example below should clarify; I have the following formula: =SUMPRODUCT((Building=$B15)*(Unit_Type=$B16)*(Unit_Line=H15),Rent_Month_Total) This formula sums the...
  3. srizki

    Conditional format if other cells have any value is the same row.

    Hi every one, I have numbers and dates etc in columns A to G, I want to highlight the cells of that row from A – G of there are any numbers in columns H to AU. Thanks Sohail Rizki
  4. K

    Based on the selection of a dropdown list, automatically insert data into adjacent column

    Excel 2010 I know how to make a drop down list, and even know how to make a conditional drop down list that changes based on the contents of the first drop down. I need a drop down list in A1, that makes B1 automatically populate with some data pulled from another sheet. Let's say on another...
  5. S

    Pasting Conditional Formats, Relative, To Multiple Cells

    Well, either Excel 2010 operates very differently from previous, or I have forgotten a huge amount about working with conditional formats. I have two columns (J & K) with dates in them (Formatted mm/dd/yyyy). If the date in column K is later than the date in column J, I want the cell to turn...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top