interior.colorindex

  1. S

    Function Not Working with Conditional Formatting

    Hi; Made a function which checks if the cell color is red or yellow and returns the word or returns nothing"". The sheet with the function looks into another workbook with conditional formatting which turns the cell into three/four colors dependent on the cell input. My issue is that the...
    • sub80
    • Thread
    • cell color conditional formatting interior.colorindex
    • Replies: 5
    • Forum: Excel Questions
  2. O

    Double click to change cell to multiple color or back to original

    Below is a piece of code from another thread where double clicking on a cell changes the cell to red. If you double click on the cell again it changes back to its original color format. I am looking to see if there is a way to add additional colors to the choices. For Example, the first double...
    • one4youman
    • Thread
    • cell cell color double interior.colorindex original cell color
    • Replies: 8
    • Forum: Excel Questions
  3. S

    VBA Cut Interior.Colorindex 15 and paste Below Lastrow then delete blank rows

    Good morning, I have rows of data that I have colored with interior.colorindex = 15. What I would like to do is to take those rows and cut them and paste then after the lastrow then delete the blank rows. Any help would be appreciated. My data is in ("A1:P100"). Thanks in advance!!!!
  4. J

    Bypassing colour limitations of Interior.ColorIndex?

    At the moment, Interior.ColorIndex (if I am correct) has a limitation of 56 colours? Is there any way I can get around that? As can be seen, after row 55, it doesn't highlight duplicates (The code highlights duplicates if that record has a duplicate) File...
    • jack2
    • Thread
    • end interior.colorindex lrow skip worksheetssheet1.rangeb
    • Replies: 1
    • Forum: Excel Questions

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