color a cell

  1. A

    Help Changing Cell Color to Based of Date referring to a specific Interior Cell Color

    Happy New Year! I am working on my yearly calendar which is on one sheet. I usually manually change the cell color to match the month and then bold Sundays (attached is my 2023 calendar) but I have been trying to get into Macros more. Unfortunately, I cannot figure out VBA to change the...
  2. C

    Create a custom "Fill Color" selection row

    Hi, I wonder if you can help me. I've got a spreadsheet that is used by around 20 people. Unfortunately, these people are self-declared not tech savvy, scared of Excel, etc. They need to color code certain parts of the spreadsheet, but they all need to use the same colors - it's almost Red...
  3. I

    Why text color change when double click.

    Using "move and copy" option with excel, I copied one worksheet and saved as another workbook. But the copied file text in cell change the color. But when I double click the cell, the color change to the correct one. I really confuse how to fix this...experts please help. Before double click...
  4. V

    How do I change selected colors of this vba automatically?

    Hello everybody, I'm having trouble changing my Macro's colors when it automatically selects fields. Does anyone have any idea how I can solve this problem? Thanks for listening. This code VBA i'm use: Sub RemoveLeadingSpace() Dim Rng, WorkRng As Range On Error Resume Next xTitleId =...
  5. L

    Change color of cell based on data in another cell--HELP!

    I have been trying tirelessly to change the color of cells based on the color/data of a cell in the same row as that cell. I keep seeing things about a VBA, but I don't know much about that. I have tried multiple different conditional formats, and nothing has worked. There is already a...
  6. M

    Excel VBA for conditional formatting of sheets to color cells with date today and next working date (no weekends)

    Hi! I am kindly requesting for a macro script that will run through all the sheets in the Excel file. The macro should be able to do the following: 1. Color the rows in yellow for a cell containing the date today and the format is ddmmmyy for most of the sheets. But there is 1 specific sheet...

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