vba color change

  1. C

    VBA Fill rows with color, but skip cells with already certain color fills

    Hi, I have the below macro that adds fill color grey to my even rows and white to my odd rows. How can I make it so this macro skips the "cells" that already have a specific color? For example: If cell "E4" has color RGB(255, 192, 0) which is the regular orange, then I want that cell to stay as...
  2. Z

    VBA to colour cells if they are equal to or greater than another worksheet cell value

    Hi All, Please could you help me. I am trying to loop through the rows in my worksheet and then if the cells in a column match a value in another worksheets cell then I need it to change to colour of the cell. My Main table has about 50 rows and the headers start in row 2. There are 23 Columns...
    • zaincmt
    • Thread
    • cell change color different worksheet match value vba color change
    • Replies: 1
    • Forum: Excel Questions
  3. L

    Change cells' color with VBA based off a pair of cells

    I'm working on a task to create a project plan (if you will) in Excel. I will have a Start Date and End Date in adjacent cells. These cells are set up as lists. To the right are corresponding date cells like a timeline. When a start date and end date are selected in the respective columns...

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