highlighting rows

Hello All! I have my Table (Table13) I want the respective row to highlight when an "x" is in column D ("Reviewed (x)") This is the formula I'm using in conditional formatting: =$D$5="x" | applied to =$D$5:$I$5 which does of course work, however the problem I'm having is because it is a fixed...

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

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

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

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

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

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

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

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

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.

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