highlighting rows

  1. 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...
  2. 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'...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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.
  9. 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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top