colour adding

  1. L

    VBA alternative to conditional formatting

    Hi all. I am working on a large data entry and reporting system in excel. Currently the area of drop down boxes covers 1.3 million cells and will probably end up double that. I was using excels inbuilt conditional formatting to grey out box's that are contain an "X" to improve the user...
    • LORDMARKS
    • Thread
    • autofiler colour adding condition formatting speeding up vba & excel
    • Replies: 1
    • Forum: Excel Questions
  2. T

    Colour shapes when certain criteria is met on different excel tab

    Hello, I'm working on an excel and have two tabs: Tab 1: in tab one I've added a picture (total ownership with all differtent owners of a plot of land) and on top of this picture i've drawn freeform (shapes) corresponding with the different ownership positions on this entire plot (let's say...
  3. M

    Change pattern colour linked to content

    Not sure if someone has asked this before, if so I can not find it. I have a sheet that needs to be formatted for printing. The text in the file is a lookup form a different sheet. What I am trying to do is colour code thing ie if the cell is YEL and change colour to Yellow, BLU to Black and...
  4. J

    Add together Values in Coloured Cells

    Hi, I have had a look through some searches and I can't find any that have answered this question before so would appreciate it if someone could assist. I have a few cells on a sheet which will be coloured red. They won't always be the same cell references, but they will always be the same...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top