Highlights Every Other Row

Apr 15, 2009

I have this bit of code that highlights every other row. I would like to modify it so that it doesn't highlight the entire rows but instead stops at the column of whichever cell contains data.

For instance if I’m using a block of cells such as A1 to C5 it would highlight A2-B2-C2 & A4-B4-C4 only. Later on if I insert data in D3 it would now highlight A2-B2-C2-D2 & A4-B4-C4-D4. Anytime that data would be inserted into a new column all row highlight would now adapt to the new length of the table.

Here’s the

Sub ShadeEverySecondRow()
Dim lRow As Long
lRow = 0
Do
lRow = lRow + 2
If IsEmpty(Cells(lRow, 1)) Then Exit Do
Rows(lRow).Interior.ColorIndex = 15
Loop
End Sub

View 9 Replies


ADVERTISEMENT

Do Not Want Highlights To Be Printed?

Nov 29, 2013

In excel sheet some times I highlight Cells, Rows or Columns for references but while printing these highlights get printed. is there any formatting tip so that only values are printed but highlights don't get printed (not even in grey scale).

View 3 Replies View Related

Highlights The Check Box In Red

Jul 30, 2009

Just wondering if it is possible to put a check box with a macro say in cell C3 that when you tick the box it changes it to green as completed, but after a set time say 2 weeks the check box clears itself and changes the colour to red to highlight that its due again. Also when you tick the check box it inserts a date in another cell say D4 when it was ticked.


Reason for this is am trying to make a spread sheet with different products that require different testing frequency, some monthly some weekly and some fortnightly. At the moment we are just using a white board and staff just tick task completed problem is they need to check when last done especially when test required is of every 2 weeks and people forget.

If I make a spread sheet and it highlights the check box in red like I want to above at least it will give them a visual reminder that it is due.

View 14 Replies View Related

Macro Highlights All Characters

Apr 3, 2007

Is there a way to pause a macro while it is running?
For example:

COL A COL B
1 2
b 4
5 5

My current macro highlights all characters in this case b.
Is there a way to make it stop when it highlights b, and make it continue running when I want? I'm using a Form for this purpose.

View 10 Replies View Related

When A Cell Is Clicked The Row Also Highlights - But How

Feb 23, 2007

I've seen a spreadsheet where the user can click on a cell, and the row the cell is in automatically highlights.

This is useful where there is a lot of columns, and it also looks pretty snazzy!

How do I do this? I know one way is to put the following code in when you right click the sheet tab and choose "view code":

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
UsedRange.EntireRow.Interior.ColorIndex = xlNone
ActiveCell.EntireRow.Interior.ColorIndex = 6
End Sub

But then I can't have nice background colours for other cells. Any suggestions?

btw, I've v. new to VBA - best to assume I know nothing!

View 9 Replies View Related

Search Filter: Highlights Only The First Value In A Cell

Sep 19, 2009

attached is the sheet u have prepared for me but there is a problem in this sheet that it highlights only the first value in a cell however my requirement is to highlight the every value in a cell if matching with the search criteria.

View 4 Replies View Related

Highlight Cells But Do Not Print Highlights

Apr 17, 2013

I have a form that I have created for our other stores to use while balancing the cash drawer.

I would like to somehow highlight all the fields that need to be entered, but need the page to still print out clearly.

View 4 Replies View Related

Click On Cell And It Highlights 2 Or 3 Cells Below?

Dec 9, 2013

I must be hitting a key by accident sometimes which makes Excel highlight the cells immediately below the ones I want as well. So, if I click in the middle of cell A1, it also highlights A2, A3 and sometimes A4 even though I haven't dragged down over them.

Why is this? I can't work out how to stop it doing it. Some previously recommended hitting F8 but this doesn't seem to stop it.

View 9 Replies View Related

Dynamic Row & Column Highlights In A Data Table

Jan 15, 2014

I have a two way data table for which the two variables are changed frequently. In the data table, for ease of reference, i usually highlight the corresponding row and column of the two most current variables the intersection of which gives you the current output. But these highlights need to eb changed each time the variables are changed 9the table is copied onto another document for presentation hence the need to keep changing the highlights).

I was thinking of configuring the highlighting process to happen dynamically, i.e. the row and column highlights change dynamically when the variables are changed.

View 7 Replies View Related

VBA Only Highlights One Cell At A Time And Won't Stop Email From Going Out

Jul 30, 2014

Trying to use VBA to prevent users from sending a form unless all fields have been completed, then highlight blank cells, and send a pop-up message that all cells in myRange need to be filled out. Otherwise, send the worksheet.

My code will highlight the blank cells, but it only highlights one cell at a time and then I have to click on the pop-up message for it to highlight the next one, and then the email still goes out.

How can I fix this to highlight all the blank cells at once, with only one pop-up message, and prevent the email from going out?

Public bCheck As Boolean
Sub SendWorkSheet()
.
.
.
.
'HIGHLIGHT BLANK CELLS

[Code].....

View 2 Replies View Related

Conditonal Formatting (highlights Cells If Any Of More Than 3 Conditions Is Met)

Jan 2, 2009

I'm looking for a formula to use with conditional formatting that highlights cells if any of more than 3 conditions is met. I saw it on this forum before, but I can't find it with a search. It was something like =or(condition1),or(condition2), etc.

View 9 Replies View Related

Condtional Formatting; Highlights My Data Range In A Row Red

Jan 22, 2009

I have a spreadsheet with conditional formatting that highlights my data range in a row red when their is no data entered in cell (E2) with this formula =COUNTIF($E2,"")>0 Now my question is...How can I make the highlighting go away if I enter information into cell (C2)? I added another condtion that said =COUNTIF($C2,"")

View 9 Replies View Related

Conditional Formatting Highlights Same Number Even If Positive / Negative

May 29, 2013

Can I use Conditional formatting (highlights duplicate values) but highlight the number even if the number is an Positive or Negative number.

It must highlight the number if it's -300 or 300 in both instances.

View 6 Replies View Related

Worksheet Cell Automatically Highlights In Different Color When It Is Selected

Mar 6, 2013

I occasionally give presentations with Excel and would like to make it easier for the audience to see a particular cell when I move to it. The cursor can be tiny, and some people have a hard time seeing the cursor, so I use the keyboard to navigate to the cells I talk about. Yet, the cell, which then has a border around it, still can be hard to see.

Is there a way in Excel to have a cell that is highlighted, that is I move to a cell with the keyboard, so that it pops out in a different font color or background or format, when I move to it, and it automatically reverts to its usual format and color when I move away from it?

View 1 Replies View Related

Use Conditional Formatting For Calendar That Highlights Workweeks Of Project Dates?

Aug 3, 2014

I think this should work but it doesn't.

=AND($B4>=D$2,$C4<=D$3)

Should look like this
Excel Conditional Formatting.png

View 3 Replies View Related

Excel Automatically Highlights Row And Column Number When Click On A Cell?

Jul 25, 2014

I am creating a spreadsheet for my job and knew a code or any way to implement this into my spreadsheet.

View 1 Replies View Related

Highlights Multiple Rows If Select Cell (formula Cell)

Oct 3, 2013

I have a matrix with numbers that each cell is composed by a function of two parameters (two columns). The formula is

"=COUNTIFS(T2:T99,"15",V2:V99,"14")",

So it's counts when in one cell column I receive 15 and in the other 14. For instance, I receive the number 3 - so I have three rows that match (the first column with 15 and the second with 14).

I want, when I select the cell from the matrix (table) with the number 3 (that I receive from the formula) it will highlight the relevant rows..

View 3 Replies View Related

Code Which Highlights A Cell Depending On Criteria Of Another Cell?

Mar 7, 2012

code which highlights a cell depending on the criteria of another cell.

Example.

In B1 I have the formula =NOW() (we all now what this means).

In B2 I have a completion date.

I would like A2 to fill with a specified colour.

Can this be done so that it works down the whole sheet, if the date is in B5 then only A5 will highlight so basically only the A cell on the same row will change depending on the date in B on the corresponding row?

View 4 Replies View Related

When Cell Clicked, Stays "clicked" Highlights All

Jan 10, 2007

What in the world did I do now? When I click on any cell, the cursor turns into a thick "+" . Then, when I move my mouse up and down the spreadsheet, all the cells the "+" touches become highlighted.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved