1.interior.color

  1. J

    Make code faster with IF THEN function

    Hello, I have the following code to sort through three different columns. If Column 5 is empty, it needs to be filled in with the specified color. However, there are times that column 5 may not be empty. When there are no empty cells in column 5, it turns all three columns(5,6,7) all blue. How...
    • Jones1413
    • Thread
    • .rangea1k 1.interior.color code empty usdrws.autofilter
    • Replies: 2
    • Forum: Excel Questions
  2. D

    Issue with VBA code - removing highlighting from blank cells.

    Hi Folks, I am working on a project to highlight cells red if they exceed certain character lengths <tbody> User ID Name Address 1 Address 2 Address 3 Address 4 Town / City Postcode </tbody> For instance, I want to use VBA to highlight any cells in the User ID...
  3. A

    Need to Match two or more rows values based on their ID in another cell

    Hi Can any one help me on below code:- first check that how many cells or times one/same id contains and then match and color code (if matches then green else yellow) company name with the similar times.Below is the code given in this forum but it not working properly- [CODE] [Sub...
  4. A

    VBA to change cell colours and font colours based on values

    Hello All, I tried the following, but it is making all fonts black. What is it that I am doing wrong? For Each c In .Range("A5:A170") If c.Value = "Ex" Then c.Offset(, 1).Interior.Color = 192...
    • asad
    • Thread
    • 1.font.color 1.interior.color c.offset c.value vbwhite
    • Replies: 2
    • Forum: Excel Questions
  5. B

    Use And in IF Statement VBA

    Afternoon My question today is I am trying to apply multiple conditions to a cell. The first condition formats the cell blue if the mod is 0. I would also like to format the font bold. (Maybe other formatting as well) The code I am using below. Thank You. Sub format_every_other_row()...

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