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...
  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...

Some videos you may like

This Week's Hot Topics

Top