shade

  1. E

    Shade alternating row where value in column "X" = 1

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

    How to shade groups of 5 rows using conditional formatting

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

    Condtional format a rangeof cells based on the value of one cell.

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

    Returning a value in another cell, when shading a box

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

    conditional formatting - shade alternate rows dynamically

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

    Conditional format a cell based on text in adjacent column

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

    Duplicates in workbook

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

    how to do a filled map of U.S county with population

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

    Excel Charting Challenge Q, special

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

    Highlight Row depending on two separate cells

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

    Shading a cell based on several ranges of numeric data

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

    Shade cells which have values in the bottom 20% of a table

    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%...
  13. S

    Shading to the right of a series of values on a graph using VBA

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

    Shade on simple chart

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

Watch MrExcel Video

This Week's Hot Topics

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
Top