no fill

  1. S

    Can I have 2 different FILL buttons in the ribbon. One yellow and one blank?

    Running Office 2010, windows 10, 64bit. So really I want a shortcut/hotkey that removes the fill from selected cell/s. I added another fill button to my custom group on the ribbon, but when I change the fill color of the one, it changes the fill color of the other. I want to have a dedicated...
  2. S

    Want background to display in gray but print white in Office2010

    So I've been working in Excel 97 on Windows XP, and in that system, I was able to set my "active window" display to light gray. Just to clarify, I was *not* changing the color of the cells - Excel still thought they were "no fill", and when printed on white paper, they were white. However (and...
  3. C

    Finding no-fill cells

    Hello, I want to determine if certain cells are filled or not filled. I also need to assign a white fill to another cell based on if the cell is white or not filled. I have: ElseIf Sheets(n).Cells(b, 7).Interior.ColorIndex = 2 Or 0 Then With Sheets("Results_STEEL").Cells(r, c)...
  4. K

    Count Nofill conditionally formatted cells.

    I have created a live calendar without using VBA. The dates in the calendar are conditional formated for weekends, every other Friday (depending on the first Friday I select) and Holidays. These cells are all set to be different colors. I would like to be able to count the conditionally...

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