Re: Flashing cell or row when condition is met,

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



It's possible to do this using VB code but it really isn't advisable, its
not like the built in function in Word. If you really want to do it, do a
Google search for 'Flashing' in Excel Programming or similar and the code is
there to be found.
However the downside is that it doesn't flash very well, it's erratic, the
screen also is erratic and it takes over the processor while its doing so,
so nothing else can be done until its stopped.
My advice is don't !
Regards,
Alan
"bioyyy" <bioyyy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:98735FE1-7EE7-4AC0-BADA-D6C778FC4F87@xxxxxxxxxxxxxxxx
> Hi,
> I need your help. I know you can help me with this-very smart. Ok, here is
> the table:
>
> Col: A B C D E
> 1 12 11 12 13
> 2 14 15 16 17
> :
> :
> 33 70 18 19 20
>
> Let's see, whenever I type a number 1 in the G1, I like to see A1:E1
> flashing (either text or background), or type #33 in G1, the whole row of
> A33:E33 flash. In other words, whenever, the integer number in G1 matches
> with any number in col A, the whole row is flahing for that match number
> in
> col. A. I hope you get my question. Your help is greatly appreciated.
>


.



Relevant Pages

  • Re: Tamron 28-75mm f/2.8 XR Di AF on a EOS 20D
    ... As regards the built in flash: I am amazed at it's power. ... Speedlite 220EX that I bought for my previous camera, ...
    (rec.photo.digital)
  • Re: Whats after the 20d
    ... The problems with a built in flash are that it takes up room in the prism ... it up with a camera lower in the line with the same pixel count. ... different sensors than the one that preceded it. ...
    (rec.photo.digital.slr-systems)
  • Re: Flash with Olympus C7070
    ... > Alan McGrath wrote: ... >> being fooled by the available light if I had the flash set on auto. ... > Sorry to hear your shots were disappointing - been there, ... you say to forget about the flash and just use ambient. ...
    (rec.photo.digital)
  • Re: Flash Loons
    ... Seems to be a little extreme, Alan. ... Do you surf with Javascript ... Flash is big and bulky and optional. ... But disabling Flash, JavaScript, etc. and whitelisting them only for ...
    (comp.infosystems.www.authoring.html)
  • Re: Whats after the 20d
    ... > The problems with a built in flash are that it takes up room in the prism ... And will really really appreciate if someone can post alongside ... the viewfinder view thru something old and bright like the Pentax ...
    (rec.photo.digital.slr-systems)