I have % figures in the following cells, E20, G20, I20, K20, L20, F24, H24, J24, G28, I28, H32, F16, J16, G12, I12, H8.
These figures are the result of a formula of other cells, with constantly changing values, therefore the % figures are constantly changing as well.
What I would like to do is highlight the cell with highest % figure, ideally to 'flash', either cell colour or flashing text.
I originally posted this question with out the code I'm using. I am trying to make a specific cell flash to catch the attention of other dispatchers. The problem is when I we try to close the active page it will automatically open. The only way we can completely close the page is to close Excel completely. Doing this though also closes several other pages that we need to have remaining open.
Public NextFlash As Double
Public Const FR As String = "B3"
Sub StartFlashing()
If Range(FR).Interior.ColorIndex = 3 Then
Range(FR).Interior.ColorIndex = x1ColorIndexNone
Else
Range(FR).Interior.ColorIndex = 3
End If
NextFlash = Now + TimeSerial(0, 0, 1)
Application.OnTime NextFlash, "StartFlashing", , True......................
This might sound daft, but im just wondering if it is possible to Flash text 2 different colours in a cell. Cell A1 will say - - - Well done. and I want it to flash blue and red, but not use VBA to do it. Can it be done or am I wishful thinking? This would be on Office 97.
View 6 Replies View RelatedI mean to format a cell in a way that it will flash if certain conditions are met. For example : to make C14 to flash if B14>0. Different colour formatting is not enough to catch the "oldies" eyes!
View 4 Replies View RelatedI need to get a range of cells to flash when they get close to todays date, I have tried but can't do it, not very good at conditional format or vba, easy step by step if poss, i have sheet if required,
todays date = 11/01/12 (in cell O1 as autodate)
title in cell K7 is date on site
in Cell K8 = 13/01/12
in Cell K9 = 19/02/12 etc....
I would like this cells background to flash if its 2 days from the onsite date
When I return to a sheet by clicking on the tab of the sheet, the sheet is not immediately visible. When the sheet does become visible a cell has a black flashing background. Sometimes, but not always, the flashing cell is the activecell. Through the activate event of the sheet I attempt to make $A$1 the active cell:
View 7 Replies View RelatedAt the moment I have two macros. One loads up a background picture into my work sheet
when I start it up, the other two are called ‘StartBlinking’ and
‘StopBlinking’.
This is the macro code I have to load up the picture:
Sheets("CASHFLOW + FUNDSFLOW").SetBackgroundPicture Filename:= _
"G:EH_Background.JPG"
What I hope to achieve is:
1. Get the picture to ONLY load up if it actually exists on the G:
drive, otherwise do nothing.
2. If value 1 to 13 is input in Cell C3, run the macro
StopBlinking.
3. If Cell C3 is left blank again, run the macro StartBlinking.
I found this spreadsheet on here and I have been trying to customize it to what I need. I am trying to have scores from skins match highlighted. I want only the minimum score to be highlighted but if there is another duplicate minimum score I don't want it to highlight anything. I also need to find a way to count the skins won by each player and have it off to the side.
For those not familiar with golf a Skin is a game where you try to get the lowest amount of strokes on a specific hole. Ex- 4 people play the hole one. P1 scores 4, P2 gets a 3, P3 and P4 get 6. The skin would go to P2 who has the lowest score on that hole.
Highlight lowest number in each column not highlighting if there are duplicates starting at L6 down to L11 and for each column till AC. And the same for the group just to the right on attached file.
On row 13 and 14 it tells me who won a skin. I want to tally up the total skins won by each player. so if Joe's names shows up twice on R14 I want it to tell me somewhere in the sheet Joe = 2
I m wondering if it is possible to cause a worksheet tab, within a workbook, to flash? What I have is a check box, that when clicked, opens up a hidden worksheet. What I would like to have happen is once the worksheet is unhidden, the worksheet tab begins to flash to show the user it is now active.
View 6 Replies View RelatedI have solved many problems with the solutions presented here.
I have multiple workbooks which contains numerous different dates.
and I need to make them flash when the dates are due within one week etc.
I would like to know what kind of command in vba or formula in excel it needs.
How do I highlight the word in B7 if I type a number or a letter in B7.
View 4 Replies View RelatedColumn A is all random dates . When the date happens on the 1st I need to highlight that row. I'm pretty sure conditional formatting is the way I need to go but have had no luck. The date format is dd/mm/yy.
View 4 Replies View RelatedWas working away on one of my spreadsheets and the black square that surrounds the cell you click on has vanished. i.e. if you click on cell A1, you normally get a black square surrounding the cell A1 to let you know that you are on it. That black square has disappeared.
It seems to affect any spread that I open but if I open a new spreadsheet it is there.
I work with many sheets that have many data columns and have used a "greenbar" formula in conditional formating but would like to have a similar formula that highlights the current row. If possible, it would be nice if this new formula would not wipe out all other formatting as it moves.
I have seen Ivan's work at www.mrexcel.com/hof001.php but it says that it wipes out other formatting.
The formula that I am currently using is =MOD(ROW(),3)=2
Is there a way of getting the current row number so that it could be
=ROW()=(current row number) ?
I have a problem regarding highlighting a specific cell, when i entered a specific date in another cell
Let me explain
If there is a Name, joining date, termination date/resignation date in cell A1 A2 & A3 respectively.
If the name is John, Joining date = 01/01/2012, Resignation Date 06/06/13
I need a formula which highlights the cell A2 plus all those cells which have the same date when i entered a date (i.e 01/01/2012) in another cell.
I'm attempting to put together a script which in simple terms finds the 'Highest and Second' highest activity and associated FTE for a given sub group.
To be more specific:
On the "Slide 1" sheet look at the values in column J starting at row 7 until blank;For each value, then search the "All Monthly Direct Activities" sheet in column C for the same value, excluding the 'Subtotal' rows;Where a match is found, compare all the values in column E for that sub group;And Find the highest and second highest figure;
Once these are found copy this figure and associated value in column B and paste onto the "slide 1" sheet.
I'm not particularly well versed in writing VB, but I've been working with the code to see if I can get this work, which I have been unable to do.
I have attached a file which may perhaps provide a greater detail than my description of the problem containing the 'Source' and 'Destination' sheets.
If I use =MAX(A1:G1) I get the highest value. Is it possible to show the next highest rather than the highest and if so how?
View 9 Replies View Relatedhow to make an object, e.g. Oval Object to flash a solid yellow & white colour? I can make blinking cells, but not objects.
View 12 Replies View Relatedhow to highlight a particular cell red if the value in one cell is less than or equal to the value in another cell. For instance, How do I make it so that the "Hours to go" cell turns red if the value in the "Actual Last Completion" value is less than or equal to the value of "Last Completed" cell?
View 3 Replies View RelatedAs said a box appears with information guiding the user to what should be entered.
I inherited this spreadsheet and would like to edit the contents of this box and also learn how to make them myself.
Also I'd like to note that the box does not respond to right clicking
I have built a spreadsheet for my business which has an annoying feature I can't get rid of. When I click in a cell I want to enter data in the spreadsheet automatically highlights that cell and the neighbouring cell. I have to move away then back with the arrow keys to get back to the single cell I want to enter data in.
View 2 Replies View RelatedI have a macro, and it mainly works, except the second part where it checks if the value is less than 7, and returns it to a white background.
The cell has a formula in it that returns "" based on another series of cells. I have considered changing that to a zero and formating, but for reasons that don't need explanation, i have chosen not to.
here is the macro. I need the second part to be activated if less than 7, as well as if the cell returns ""
What is the keyboard shortcut for highlighting cell? Can a frequently-performed task be assigned a keyboard shortcut by user? If it is done by VBA
View 4 Replies View RelatedI am getting a debugging error when I try to highlight the first row of a column that is sorted. the error occurs on the "if .autofiltermode then" line. the code does highlighting like I want but is giving me a run time error.
HTML Code:
Private Sub Worksheet_Calculate()
ColorAutoFilter
End Sub
[Code]....
I have a cover sheet to a workbook that holds hyperlinks to its relevent page. Several of the hyperlinks link to the same page but different relevant cells. However it is not overly clear which cell is active when you click the hyperlink. What I would like is for the active cell to be highlighted on the page. EG hyperlink 1 links to page 1 cell A2 & hyperlink 2 links to page 1 cell B6 - I would like A2 to be highlighted when accessed by hyperlink 1 & B6 highlighted when accessed by hyperlink 2.
View 9 Replies View Relatedin this sheet i have 3 groups of data. group 3 is the sum of group 2 - group 1.
how can i make the cells highlight that relate to the cell sum in group 3.
i.e when i click cell b38 cell b21 and b4 should highlight.
Have a spreadsheet shows 4000 warehouse locations (location of products). Each cell is a location in the warehouse (ba050, ca809, etc, actual warehouse locations, not grid ref); some products have more than one location, the locations are always next to each other. I import a text file into the workbook which tells me which product has more than one location (2, 10, 50, etc), that’s all I’m interested in ( multiple locations).
What I’ve done so far is to use vlookup to look at locations in file and allocated the number (the number of locations that product has) next (next column) to the cell that correspond to that location. What I need is a macro or formula that will look at the number and than highlight that many cells up or down the column, according to the number in the cell to the right (5 in cell, highlight 5 cells, 50 highlights 50). The warehouse runs up one aisle and then down the next and so on. So I need to be able to highlight cells up one column and then down the next and then up, then down and so on.
Multiple locations change on a daily bases, so need a quick way of updating 4000 locations.
New to excel don’t know if this is possible or not. Learning as I go.
Need some assistance.
Sample below.
Only interested if a number is returned, “******” can be ignored as will hide all columns expect ones with locations. So:
BA020 returned value of 4, so would like to highlight (any colour) BA020, BA029, BA040, BA049.
BB780 returned value of 2, so would like to highlight BB780, BB789.
POSSIBLE?
BA090 2 BA100 **** BB749 **** BB739 ****
BA079 **** BA089 **** BB760 **** BB750 ****
BA070 **** BA080 **** BB769 **** BB759 ****
BA059 **** BA069 **** BB780 2 BB770 ****
BA050 **** BA060 4 BB789 **** BB779 ****
BA039 **** BA049 **** BB800 **** BB790 ****
BA030 4 BA040 **** BB809 **** BB799 ****
BA019 **** BA029 **** BB820 **** BB810 ****
BA010 **** BA020 4 BB829 **** BB819 ****
A while back I was assisted with trying to prevent excessive screen flashing...
I was originally using the Application.ScreenUpdating=False method...but it was still a little jumpy... so Richard Schollar (a valued member in our forum) helped me with this code and it seemed to work...
Now I am trying to apply it again to another macro and it is not working so well. The thing I found is that on some people's computers it does work well, but not on mine.
Does anyone know why that is and how I can fix it so it doesn't flash on mine either?
Any way to make a button to blink if by the user form?
What I mean: I got a "UserForm", it got 9 buttons and each of them have a macro (everything works perfectly), but is there a way without affecting the current macro for each button, somehow when pressed chosen me button, it flashes while delivering its intended macro?
Sample:
UserForm:
in there
Button
in this button have a macro
Sub blqh_blqh
hfhglhgd
vfdbdfbd
End sub
..........​follows another macro to the button flashes................
I have a VBA macro that sort several worksheets during th e processing but the screen flashes it move between worksheets. I would like to be able to just show a messae or have the display stay on the strting worksheet
View 9 Replies View Related