cell shading

  1. A

    excluding condtinally formatted cells from calculation based on color and font with vba

    I have created the following function to calculate the sumproduct of two ranges of cells, but only for cell pairs which do not share a cell shade or font color which matches that of another specified cell. It works fine for cells which I have manually formatted the cell shade and font color...
    • alosled
    • Thread
    • cell shading conditional calculations conditional format vba & excel
    • Replies: 1
    • Forum: Excel Questions
  2. M

    VBA Deleting Columns based on cell shading

    Hi All, The worksheets I have, require deleting all columns shaded green on row 13. Up to and including column 150. I have a spreadsheet with headers on row 13, and a few thousand rows of data thereafter. Variable number of columns, starting from 100 to several hundred depending. My problem...
    • mackius
    • Thread
    • cell shading delete columns help macro stuck vba
    • Replies: 1
    • Forum: Excel Questions
  3. B

    Cell Shading + VB

    Hi,I am working with Excel 2003 and would liek to automate cell shading.my criteria is text based and ther are 8 permitations so conditional formatting is out of the question.utilising VB i have managed ot gt teh cells to colour as required when i populate with the the relevant info using the...

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