formatting color

  1. M

    Conditional formatting for multiple numbers

    I want to highlight certain numbers in the list below. Here are the numbers I care most about: 0, 15, 20, 25, 30, 40, 45, 60, 75, 80, 90 My preference would be to highlight any number not listed above in red. Another option would be to highlight any number that IS on the list above in...
  2. J

    Formatting of ActiveX Combo Box

    Is it possible to "conditionally format" an ActiveX combo box like you can a cell? What I am wanting to do is require a selection to be made from the combo box. I would like for the box to be red until a selection is made. Also, which is better to use? ActiveX or Form controls? I am very green...
  3. J

    Conditional Formatting based on two cells

    I am trying to do a conditional formatting formula. I have Columns M and N. Both are either Y or N values. I need a conditional formatting that will highlight both cells in the row for M and N if M=Y and N=N. Now column M can also equal N and column N can also equal Y. I just need it to only...
  4. H

    Conditional formatting

    Hi, I have a large dataset which should be formatted with green, yellow or red color based on the value compared to the value in another target cell. I want the negative value to be treated exactly as the positive value (negative deviation is equally bad as a positive deviation). This is where...

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