Idiot's Guide to Flashing

Drewmyster

Board Regular
Joined
May 16, 2007
Messages
145
Office Version
  1. 365
Platform
  1. Windows
Hi all, I have no knowledge or experiance with VB, but I am wanting to perform a task in MS Excel which requires some VB macros.

I want to be able to make cell's flash to highlight certain data in a spreadsheet.

To do this I have to enter special code, but I don't know how or where.

I am using the very latest MS Excel 2007.
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
This should help: http://www.tmehta.com/tmxl/dbfind_byid.asp?id=14

To enter the code, you first need to left click on the Office Button > Excel Options > Popular > Show Developer Tab in the Ribbon and OK. Then on the Developer tab click Visual Basic then Insert> Module then paste the code into the white space.
 
Upvote 0

Drewmyster

Board Regular
Joined
May 16, 2007
Messages
145
Office Version
  1. 365
Platform
  1. Windows
Well I have the developer tab now and can see how to enter new macros, but I dont quite follow all that the link provides.

It looks very basic, but I cannot seem to achieve this.

What does this mean;

For any cell that you want to 'flash' put in a conditional formatting condition (using Formula Is) of =MOD(SECOND(NOW()),2)=1. Set the font/pattern/whatever as desired.
 
Upvote 0

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Select the cell that you want to flash.

On the Home tab click Conditional Formatting > New Rule. Click 'Use a formula to determine which cells to format' and in the Format Values box enter

=MOD(SECOND(NOW()),2)=1

then click the Format button and apply your desired format then click OK twice.
 
Upvote 0

Drewmyster

Board Regular
Joined
May 16, 2007
Messages
145
Office Version
  1. 365
Platform
  1. Windows
Well forgive my Homer Simpson brain, but I did that, and created a macro, but the whole spreadsheet flashes, and not the cell I formatted the new rule for.

Once I know how to use this macro to it's effect, I can manage it on my own. But I've never programmed anything before, so that's why I'm limited on the knowledge.
 
Upvote 0

Drewmyster

Board Regular
Joined
May 16, 2007
Messages
145
Office Version
  1. 365
Platform
  1. Windows
Please could someone just conclude in simple terms how I go about making 1 cell flash and stand out from the rest.
 
Upvote 0

Forum statistics

Threads
1,191,671
Messages
5,987,957
Members
440,121
Latest member
eravella

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top