c.interior.color

  1. J

    Compare two worksheets

    Hi, I have the code below but not working want to find difference between JAN/JUL tabs both column A but not working I kow there's a difference because one has 316 rows and the other one 315 then there's one line missing in JUL tab has only 315. here is the code: Sub compare() Dim myRng As...
  2. S

    Conditional Formatting VBA Question

    Hello everyone, I have a question about how to use VBA to format a cell based on another range of cells. For example using the code at the very bottom is pretty close to what I was looking for but need the following: I have a range of cell U3:FG145 that is either a blank cell or not blank...
  3. D

    Limiting a conditional message box to pop up only once?

    Hi Folks, I have some VBA code that highlights cells which exceed a certain number of characters 'Red'--- until the cell character count drops below the condition, then the cell becomes un-highlighted. At the end of the VBA I put a message box to inform the user their cells exceed character...

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