shade

Hi, haven't been able to find an answer to this anywhere so here goes: I want to shade alternate rows in a selection when a value in another column = 1. So, for selection H11:T37, where the value in cell $D11 (through $D37) is 1, I want to shade alternate columns. The reason for this is I...

I want to shade groups of 5 rows. Basically shade 5 rows, 5 rows not shaded.. I have experience doing every other row, but not grouping 5 rows at a time. Thanks or any help. Nick

Hello everyone. I need to conditionally shade a range based on the value of single cell. See Image: I need to shade g25:m30 based on the value of G28. (edit - was G26) I have selected the entire block, went to conditional formatting and set up a formula based rule with =g28="QPM" What...

I'm working on a table, and I want to be able to pick up a value from one cell, when i shade a box and copy it to another sheet. Any ideas on how this can be accomplished.

Greetings all - I have a spreadsheet with data in range B8:AB200. Sometimes the range would be less than row 200. I'm needing to shade every other row, except if the bottom most row is blank. In other words, sometimes every other row from B8:AB164 would need to be shaded if B165 is blank.

Hi, This seems pretty simple but I can't get it working. Lets say column A is a Yes or No column. I want column B to shade in red if a "Y" or "YES" has been entered into column A. Thanks!

I'm sure this has been asked, but I can't find it. I have 2 sheets of my workbook... sheet 1 is about 6000 rows: 12345 49318 57419 64753 35489 sheet 2 is about 1000 rows: I want to shade the rows in sheet 1 that appear on sheet 2? I know it's not that hard (if you know what to do), I just...

I have a set of data for the state of Texas. Column A has unique zipcodes, column B has counties (not unique since multiple zipcodes fall into each county), and column C with a population metric (there are duplicates since data is county population). I want to build a map that fills the...

Hello! I'm wondering if a certain chart can be created in excel. The base data (blue) contains information about bacteria concentration levels for various depth ranges/cohorts/blocks. I have no problem charting the base chart in excel. The problem is, I want to shade a specific region under...

Hi I'm stuck with this one, the below is an example of what I'm trying to achieve. I need to highlight the rows depending on the values on D and F. I've done =NOT(ISBLANK($P1)) in conditional formatting to highlight the rows when a date is entered in column D but I can't figure out how to...

How do you shade a cell based on multiple ranges of data? e.g. A value of... 1 shades red 2-3 shades orange 4-5 shades yellow 6 shades green

I have the following table in my spreadsheet. I'm trying to shade those cells with values in the bottom 10% (bottom decile) of those values in pink colour, and those cells with values in the 10-20% (next bottom decile) in orange colour. Appreciate any help with this - thanks. <TBODY> 28%...

Hi, I was wondering how to shade to the right of a series of values on a graph using VBA. I understand how to shade left using this link--http://peltiertech.com/Excel/Charts/VBAdraw.html , but I can't get any shade right procedure I come up with to work correctly. Sara

I have a chart showing client growth over the last 15 years for a company and I want to have a shaded area representing time periods of economic difficulties. I tried making another series into the chart but that didn't work because of the timing of the economic difficulties took place over...