A simple way with which you can draw attention to a cell or special add- in in our Excel sheet is by setting a background color on it without first creating a flashing color effect in the cell.
So that the user to whom the Excel document will be directed , go directly to this section to observe the information that requires the expected importance.
Within this post, we will leave you the necessary tools, with which you can carry out this effect in an Excel sheet for your projects or lists that need to be highlighted.
Step by step to create flashing style of cell in Excel
Start by clicking on the start bar and on the search bar, in which you will locate the “Excel” program or otherwise, if you are on your desktop, click on it to open it.
Next, open the program, you must go to the top banner and look for the “Cell Styles” button; A window with several styles pre-defined in Excel will be displayed.
Once this is done, note that you can make use of the styles that are determined or, failing that, you can also create your own style by clicking on the ” New cell style ” option . There you will see that a new dialog box will open in which you will be allowed to make a completely unique and different style.
Each of the selection boxes shown in the dialog box correspond to one of the tabs of the dialog box called “Format cells” .
Having created the new style, it will be mentioned to exemplify with the name “Intermittent” which must be present to continue with the configuration.
Creating the frames
Specify the previous steps, now you must begin to take the code that is essential in order to carry out the application of the “intermittent color in the Excel cell”.
Next, the ” Microsoft Visual Basic ” editor will open, which will write these commands to make the opening and closing events, so that the cells flash when the file is started and at the end, the configuration is maintained:
- SubStart ()
- Next = Now + TimeValue (“00:00:01”)
- Start Color
- WithActiveWorkbook.Styles (StyleName)
- If.Interior.Color = StyleColor Then
- .Interior.Color = StyleColor2
- .Interior.Color = StyleColor
- Application.OnTime Next, «Start»
- PrivateSubStartColor ()
- IfInitiated = FalseThen
- StyleColor = ActiveWorkbook.Styles (StyleName) .Interior.Color
- Started = True
- SubStop ()
- Application.OnTime Next, “Start”, schedule: = False
- ActiveWorkbook.Styles (StyleName) .Interior.Color = StyleColor
By copying these codes in “Visual Basic” you will be indicating to the selected cells that they should blink second by second based on the execution.
Pasted the code, place the cursor anywhere in the code and press “F-5” this action will execute the code and the cells will begin to blink intermittently second by second.
At the end of the use of this file, you must save it as “Macro-enabled Excel workbook” although this, when starting the file again, you must start the effect by repeating the procedure.
Now, so that it continues to work when opening the file; it will go to “ThisWorkBook” which appears in a panel on the upper right side of the “Visual Basic” tool.
You will click on “ThisWorkBook” by placing the code ” Workbook_Open () ” by typing the procedure “Start” to call the book and initiate the blinking action in the cells. Now to close the file and keep the settings, type “Workbook_BeforeClose (Cancel As Boolean) and type” End. ”
Then, you must proceed to save the configuration, so that it remains in the format of “Book for Macbook” in this way, the configuration will remain saved in the modified file and when it is opened, it will continue to flash .
With this explained, now you can point out the cells you want for the user who will use it so that they do not go out of focus.