Idiot's Guide to Flashing

[Drewmyster]

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.

 

[VoG]

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.

 

[Drewmyster]

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.

 

[VoG]

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.

 

[Drewmyster]

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.

 

[Drewmyster]

Please could someone just conclude in simple terms how I go about making 1 cell flash and stand out from the rest.