highlight cells

  1. U

    Highlight Rows (Alternating Colors) Based on Cell Value

    All, I have values in Column H in a file that could be big or large (so the # of rows is unpredictable) Data could be something like: 1 2 2 3 4 4 4 4 5 5 6 I'd like to do the following: Highlight all consecutive duplicates as one color, and extend highlight to the entire row, not just that...
  2. J

    Highlight cells based on selected cell loop.

    Similar to this thread http://www.mrexcel.com/forum/showthread.php?t=616627 I am looking to highlight values based on a selected cell. However, would also like the other values in the highlighted cell's row to be used as inputs for the next search and highlight those values as well. Can...
  3. L

    Conditional Formatting wth drop down menu - need to keep the formatting consistent based on one drop down choice

    I have Excel 2010 and I have looked high and low for an answer to this question . . . I have a drop down menu that changes the values in a corresponding table. The possible drop down selctions are: <TABLE style="WIDTH: 128pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0...
  4. S

    Highlight Files

    I wish to open each xls file one by one in the main directory D:\BRDSORT and each of it's subdirectories upto 2 levels and run the following macro on Sheet1 of each file. Macro: Sub Highlight() Range("E9:H13").Select With Selection.Interior .ColorIndex = 34 .Pattern =...
  5. Q

    Highlight cells

    I have a question. Here is the example: If A1=20, I want to auto highlight 20 cells. If value in A1 change, the cells highlighted auto changed. How can I do it in Excel 2007?
  6. P

    Conditional Formatting help

    Dear All, I have one column of Site ID's sorted with respect to certain ratio. Also I have Same Site ID sorted with another criteria say demand. I would like to select or highlight site IDs with Ratio greater than 5 from sorting with demand column. Can you please help with it? E.g. Site...
  7. R

    How to highlight a cell that contains more than 50 characters using conditional formatting?

    How to highlight a cell that contains more than 50 characters using conditional formatting? Please let me know your suggestions. Thank you in advance.

Some videos you may like

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