vba code for condtional formatting

[rv02]

Hi All

I am writing a Excfel Macro to highlight and blink the cell (i.e. the cell flashes) when a certian croteria is reached.

I would really appreciate any help or a sample code to do this.

I have a spreadhseet with the amount that customers spend and if a customer spends more than 1000 the name of the customer should be filled in yellow background and the name should also flash. If they spend between 500 and 1000 then name should be filled with red and flash.

Thanks in advance

[nathansav]

You'll need to start messing with Application.OnTime in VBA for that, i think.

[JOHN H. DAVIS]

Does this help?

http://msdn.microsoft.com/en-us/libr...ffice.15).aspx

http://www.vbaexpress.com/kb/getarticle.php?kb_id=891

http://www.ozgrid.com/forum/showthread.php?t=80432

[rv02]

thanks for this. I will give it a go, it does look to do what I need

[rv02]

I cant seem to be able to get this working, sorry about this but I am new to VBA.

Below is my code which sends an email out if a customer has spent certain amount (>1000 or between 500 and 1000). What I need is if a customer has send more than 1000 then an email is sent out and the cell B2 (which has the name of the customer) to blink, and the same all the way through. I have also attached my spreadsheet with fake names for reference).

Any urgent help is appreciate it.

Please Login or Register  to view this content.