cond format column

  1. M

    Conditional Format Columns Only When Filter Applied

    I need help figuring out how to conditionally format a column or columns based on another column being filtered or not. In other words if the Match column is filtered for either true or false, then I need formatting applied to the Value 1 and Value 2 columns and then have that formatting removed...
  2. Z

    Excel conditional format entire column based on cell value

    I have a spreadsheet that has a 7000 rows. My sheet does have a header row. Column G is not supposed to have any cell with a value greater then 1000. I want to highlight red the cells with these "bad values". This I accomplished with the conditional formatting cell value greater then 1000 and...
  3. R

    Insert text in cell based on conditional format?

    I'm new to Excel and use Mac Excel 2011. I understand the basics of conditional formatting but I can't quite figure out how to enter text in one cell based on whether another cell is greater than a third cell. Here's what I want to do: if a1 <= b1 then insert text "BUY" in cell c1 If I...
  4. C

    Conditional Formatting Dynamic Column Based on Cell Value

    I'm trying to find a way to use conditional formatting to highlight a column based on a value in the cell on the column's top row. The length of the row changes from day to day so the value can appear in different columns but will appear only once in that row. For instance, I have a row...

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