shading

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

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

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

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

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.

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: https://peltiertech.com/fill-under-between-series-in-excel-chart/ ) Well - now I need to only have a shaded region if one of the lines is...

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

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

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

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.

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

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

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

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

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

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-- http://peltiertech.com/Excel/Charts/VBAdraw.html , but I can't get any code to work correctly for shading inbetween two series. Sara

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

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

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