highlighting rows

  1. J

    Macro to select block of cells based on reference and hightlight cells in alternating colour

    Hello, I have reference cells in column A which multiple rows in a block can be the same reference value. They arent in a numerical order so cant select evens/odds but I want to highlight the alternating ‘blocks’ of reference cells to make it easier to see the change in reference. If someone...
  2. P

    Help with conditional formatting

    https://drive.google.com/open?id=1iyKH3DkICLzOlxux7EhmLkuyx_ljMCZc Hi All, Can someone please help me with what I think is conditional formatting? I have included in the above link a copy of the worksheet I am on. What I would like to do is highlight the rows based onthe contents of columns...
  3. RADTorta

    Highlighted Row question

    Hello, I have this one code i found online (I used the 3rd code listed and took out the column part) that highlights an active cell's Row/Column and it works fine, and even when i sent it to my colleagues it worked fine, however they get this error when they opened it. "Run-time error '91'...
  4. M

    Highlight entire row if duplicates exist in the same column

    I am trying to highlight an entire row if there are duplicates in Column B. The duplicates can either have COR, ENC, or ENA at the end of the text. Here is an example of how I need it to look: The numbers are not sequential in Column B. The next Item No could be SFC.....COR, Blue123-ENC...
  5. T

    Conditional Formating - Column and Row Highlighting

    I have a query relating to conditional highlighting - specifically highlighting a cell's column and row based upon whether it contains data or not i.e. if it is blank, it's column and row remain unhighlighted, but when it contains data, it's column and row should become highlighted. I could...
  6. D

    Conditional Formatting issue

    I'm trying to highlight a row (columns 1-5) in a color based on two criteria: 1. The cell in column 1 of the previous row must not be blank. 2. The cell in column 5 of the current row must be blank. Here is what I have put in as a formula...
  7. X

    Using Conditional formatting with subtotals

    I am trying to work out a spreadsheet that I am using conditional formatting to highlight every two rows. I have 2 lines for each item and i need them to be grouped together. I can get the formula =mod(row(),4)<2 to do this, but then when i go to add the subtotals for each section it screws up...
  8. cgeorge4

    MacroProblem: Highlight (color) Rows that Meet Criteria from a List

    Hello, <TABLE style="WIDTH: 432pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=576><COLGROUP><COL style="WIDTH: 48pt" span=9 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent...
  9. M

    Highlighting Macro

    Scroll down windows in Cells E3:E25. Source =$T$7:$T$14 When option T14 ("Complete") is selected, I want the corresponding Row to be highlighted yellow. Rows have highlight prior to this. How would I go about this? Thank you for any help in advance.
  10. D

    Highlighting Rows

    Afternoon All, I am hiding the Headings when my spreadsheet opens. Is there a way in VB or another method that i can higlight the row of the cell i click within a range. Thanks in Advance. Dave
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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