1. E

    Auto Highlight Cells

    Thanks in Advance: The objective: Identify each mobile device user (and device) who hasn't used their device (at all) - i.e. no voice min. used and no data used over the past three consecutive months (as defined). Note: This is a monthly report so actual months change. My column E will...
  2. E

    Shading Every 3 Column Headers

    I have a header row where I want to alternate the shading of every 3 columns within a specific range of columns. For example, A1, B1, C1 Shaded D1, E1, F1 Not Shaded G1, H1, I1 Shaded J1, K1, L1 Not Shaded M1, N1, O1 Shaded Is there a way to do this WITHOUT having to enter each cell for...
  3. D

    Detect fill colour in cells

    I have a conditional formatting that shades cells based on my criteria, however if the cell already as shading I want to leave it as is. How can I do this please? Thanks
  4. B

    IF a cell is shaded?

    Hello, Long time lurker - thanks for all the great solutions and tips that I have harvested from this forum so far. My question is: Is it possible to use use the IF function to react to whether a cell is shaded, and shaded a certain colour? Context: I have a budget template document with...
  5. O

    Conditional Formatting to shade alternate Rows.

    Hey everyone, Recently I came across a solution for shading alternate rows using Conditional Formatting. For example =MOD(ROW(),2)=0 However, instead of shading an entire row, I want to shade from Column A to up until Column L. Would that be possible? Will appreciate any help, thank you.
  6. M

    Conditional shading between two lines in a graph?

    So I found plenty of help online about shading the region between two lines and successfully got it working for my data (specifically using this website: ) Well - now I need to only have a shaded region if one of the lines is...
  7. S

    Macro to to clear leading apostrophes, but not shading?

    I have a Worksheet with 7,000 rows, some of which have shading. In one of the columns, I started the last 4-digits of a credit card number with a hyphen. Over time, I have come to see that if you start the numbers with a hyphen, it requires you to have the hidden, leading apostrophe, which is...
  8. K

    Shading under intercept line [CHART]

    Hi Everyone, I have a problem with the shading area under the 2 intercept lines as photo below. I would like to have the shading under the interception of the yellow area and orange line as blue shading in the photo. However, the problem here is I cannot make the blue shading fully shaded...
  9. T

    VBA Help with shading every other row

    Hi all, I am trying to make a spreadsheet easier to read, the sheet has many lines and varies in length. Column B will always have something in so this can be used to find the end of the data. I am trying to shade in from B to S then miss T and shade U, the shading needs to start from row 5...
  10. B

    Row insert copies down cell shading. Can this be avoided? Copying formulas preferred though.

    When I insert a row in VBA the default behaviour of excel is to copy the cell shading from the row above it. I would like to stop this from happening. It would be nice though if it copied the cell formulas from below it though.
  11. S

    IF Statement Applied Across Columns?

    Hello all! I can't quite figure out what I'm doing wrong here. I've got the value "250" in F21. Then in G21 through G25, I've got a number of values (this is all for a budget sheet, where 250 is the max allowed spending in a category and G21:G25 is all the purchases made in that category). I'm...
  12. DPChristman

    View Code - VBcolor

    I have a spreadsheet (form,really) that contains a lot of automatically updated fields from other spreadsheets. Because of all the activity in this document, I don't want to lock any cells. However, to give my users the ability to identify the current active cell. I found an used this...
  13. DPChristman

    Automate Conditional Formatting

    I have a large spreadsheet that consists of 250 Districts, and about 25 Zones. On this spreadsheet I am capturing totals by District and Zone. Based on an individual cell, can I set a conditional format (color) for that entire row. Example below: I want all my district totals to be shaded one...
  14. C

    Shading a Calendar (If/Then?)

    I am making a calendar for work. We are a flooring company that contracts through a large nationwide home store. The calendar I am making will go in these stores so that the personnel will be able to set up measure dates with the customers while they are in the store (rather than us calling...
  15. L

    Conditional Formatting Only Applying to One Column

    I have two similar worksheets that both have a large amounts of data. I conditionally formatted one to have every other row filled light blue, to make it a little easier on the eyes. On my first worksheet it worked great, but when I tried to do the same on the second worksheet, it only applied...
  16. S

    Shading inbetween two sets of values on a graph using VBA

    Hi, I was wondering if it was possible to shade between two separate series of values on a graph using VBA? I know how to shade left using this link-- , but I can't get any code to work correctly for shading inbetween two series. Sara
  17. jmh2008

    Update row shading

    I added/removed rows from from excel table, so now the table has some dark blue rows together, some light, instead of light, dark, light, dark, etc. How can I update the table back to the light, dark, light, dark rows? I tried removing formats, but that takes away my date formats, etc. Thanks...
  18. J

    VBA for shading and borders

    Hi, I am trying to write vba code that will highlight the row in the range if a field is over a certain percent. The column number won't change but the number of rows will. I'd also like the code to automatically work on all tabs of the workbook when a button is clicked. Data Info: Currently...
  19. N

    Cell shading dependent on other cell

    Hi, I have a problem that is really bugging me. It sounds really simple but I can't get it how I want it: I have a project with 2 sheets: "sheet1" and "sheet2" If I change anything in a specific cell, lets say cell A1 in "sheet1", I want a specific cell in "sheet2", lets say B4, to be an...

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
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 "".
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