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.
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.
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!
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.
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..
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 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?
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?
I would like for a vba programmer to tell me if the following program can be written before I attempt to code it. When I open Excel I want to see cells containing names in a square array with red backgrounds. As I click on each cell I want the cell to turn green and I want an alphabetized column of the names to have a 1 recorded(after I click) indicating that the person is present. If a person's name is red then I need a 0 recorded. If possible, I would like to be able move over one column each day that I take attendance by clicking on a cell in a row above the column of names. I am a math professor and I write computer code most every day but I have only written some small routines in vba that did not involve events.
I'm trying to double-click a cell to edit the contents, and I am off a few pixels, it treats the double-click as a double-click on the cell border, not the cell contents, and the focus jumps to another cell in the direction of the border instead of going into edit mode. The effect is as if I had pressed Ctrl and the arrow in the direction of the border I clicked on.
The only way I've found to disable this is to turn off the option "Enable fill handle and cell drag-and-drop", but unchecking that also disables actually useful things, like dragging the corner of a formula call to copy it down, etc.
Is there a good way to disable this cell jumping when I accidentally double-click a cell border?
i want the user to be able to change the cell color on the click of a command button. the worksheet is protected. when the user click the command button the active cell changes to red and offsets by 1. then the work sheet is locked again.
The two problems I am having is 1. I want the range to begin from row 10, column k to column FD. all cells down
the second problem is the current code allows me to edit locked cell columns A to J ...
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
I have a spreadsheet where I can change the colour of a cell by clicking the mouse, I also have text in many of the cells.
What I need to do is protect (lock) the text so that no one can change the text in any of the cells, but I still want to be able to change the colour of the cells by clicking the mouse in that cell.
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).
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.
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.
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.
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,"")
Is there a way (non vba preferred) to set up a button that will delete values in a set of 10 or so cells. I make hard fill updates to a tab each month and it would be more effecient if I didn't have to go through and wipe all the old information out.
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.
Any way to make it so that a cell can remain locked but be able to click a hyperlink? I need the cell to remained locked so nobody can alter the hyperlink name and value but I would like users to be able to click it and have it open in their browser.
I have a spreadsheet that has several formulas that update once all the values are inputted however I noticed that if I drag the formulas down the column, the cells does not update until I click the save button.