I got a macro from the site on blinking text. What I would like to know is whether blinking text can be used in a formula. eg, If A1=B1, B1,"ERROR".
Been trying to find one for a long time.
Cheers
Gaggu
I got a macro from the site on blinking text. What I would like to know is whether blinking text can be used in a formula. eg, If A1=B1, B1,"ERROR".
Been trying to find one for a long time.
Cheers
Gaggu
Why, you want to send a percentage of your users into shock?
Blinking text is awful, obtrusive, and might even be illegal in some countries.
Don't do it.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I am looking for blinking text only if an error occurs. I do not want it continously. The worksheet is used by only a few people, who work with me. Sometimes when the data input is wrong, I would like to be warned.
Thanks for your reply, I do understand your point.
gaggu
It would only show them how often they enter bad data I don't see the harm in that! ()Originally Posted by xld
LOL! So much for advertisingOriginally Posted by xld
gaggu,
Also, try to stay away from message boxes. Those are pretty annoying too. Why not just use conditional formulas? Then just color the cell red or something?
New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
In the UK we have disability legislation that all applications have to comply with. I cannot remember the letter, but I beleive that blinking text is not allowed within this legislation.Originally Posted by malik641
A better way IMO is to use conditional formatting to highlight the errors, just as effective, without the downsides.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Interesting. If you ever find any material on it, I'd be happy to read it.
And I agree, conditional formatting it should be.
...Just noticed, that's what I meant to say in my previous post, not "conditional formulas".
New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
Thanks for your help, guys. I went with conditional formatting. It works GREAT.
Gaggu
Just a FYI:
Blinking lights like strobe lights or even in this case blinking text can cause a seizure in people that are epileptic.
"Intellectual passion occurs at the intersection of fact and implication."
SGB
I think I made that point 18 days ago.Originally Posted by Carl A
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Yes, xld, I did take your advice. Thanks a lot. for some reason, i could not log into the chat. Then went on a 2 week holiday.
Cheers