Beloved experts in the house,
I've a data list of numbers in in 4 column, so I discovered that there move with a unique patterns and formation.
So the question is, how can I search for combinations of patterns in the 4 column at once.
Hi,
I have a procedure that set / reset the pattern of the currently selected cell which work fine but I would like to set the pattern color too so I added the line in blue:
Public Sub SetReset_Pattern(thePattern, patternColorIndex)
With ActiveSheet
If Selection.Interior.Pattern =...
I'm using this code and need to change the color. Is there a short chunk of vba code (Sub) I can use to identify other cells individually to find out the code equivalent?
I've found cross refc charts such as these Color Palette and the 56 Excel ColorIndex Colors that show RGB color numbers...
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.