cell.interior.color

  1. B

    Apply VBA Code When User Has Multiple Sheets Active

    The issue i'm have is i'm trying to unprotect two pages uncolor cells on two pages print those pages and then recolor and reprotect. Sometimes the User will print one page sometimes two. When printing 2 pages they have to select the 2 pages with control + click which makes both pages active and...
  2. M

    Copy last formatted cell into another cell in the sheet

    Hi, This sheet is to perform a raffle, with people's names assigned 1 to 100 in the range TargetRg. It colors random cells orange as a build up, then selects a last random cell and colors it green. The code I'm currently using is below. It works exactly how I want it to, until the last part. I...
  3. J

    IF THEN Function and Color Cell

    Hello, I am having trouble figuring out the code to do the following: If the data in column A says "Internal" and column B is empty then I want column B to fill with: cell.Interior.Color = 16776960 If there is data in column B, I don't want it to do anything. If the data in column A...
  4. G

    VBA Offset Color property not Working

    Hi, I have a code as below, the Offset Color property is not working, please suggest Private Sub Worksheet_Change(ByVal Target As Range) Dim cell As Range If Not Intersect(Target, Range("C3:AG74")) Is Nothing Then Unprotect Password:="pass" For Each cell In...

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