conditional-formatting

  1. P

    Trying to find a ? (question mark) in the text of a cell (Conditional Formatting)

    I am trying to find and highlight any cell that has a ? in the text of the cell. However when I do the Conditional Formatting, it is highlighting EVERY cell even when there is no ? in the cell. Could you please advise? ABCDE2908POL3362Westn Europn Pol Sys114911592909PAF9615Who Makes...
  2. A

    Conditional cut and paste row range by quantity of columns

    Hello, I'd like some help from you, since I'm a newbie here. What I need to achieve is: Giving a table with the first column A with a type of data and subsequent columns with data to be arranged: I'd like to cut the values in rows that exceed 8 columns and insert paste them into the below row...
  3. freelensia

    Conditional Formatting did not work with SumProduct and Search array formula

    Hi, I have a table called BadSyntaxTbl with a column called Bad Syntax. It looks like this: Bad Syntax <!-- b-->< /b> % { I want to apply conditional formatting to a range of cells. The formatting would apply when any of the terms in Bad Syntax column are found anywhere in the formatted cell...
  4. P

    Dynamically adding values from a list based on certain criteria

    I am creating a spreadsheet that models the sale of some single family homes. I have built a sale schedule that says X of the homes are to be sold per month, and I am then looking to multiply that X number by the appropriate values (the values are not the same, and range from $300,000-$450,000)...

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