Flashing A Column When Condition Met.

[cyliyu]

Is it possible to make the column wording flashing based on another column condition?



e.g. When Column P = "Yes", then the date at Column B will flash. This is to indicate to the end user so that they do not required to scroll and check whether the condition met.

 

[Chihiro]

I'd not recommend flashing approach.

1. There is no inbuilt flashing animation. Hence, you'll likely need to change fill color on each flash iteration.

2. This requires VBA and or external library.

3. Hurts your (my) eye.

It is far better to use some other method to draw attention to specific cell/data.

There are few ways to approach this.

1. Userform using listbox to list only items that meets condition.

2. Conditionarl formatting

3. Advanced filter in place

etc etc.

 

[vletm]

cyliyu
... depends how many 'flash' do You need and so on ... sample

 

[cyliyu]

There are few ways to approach this.
1. Userform using listbox to list only items that meets condition.
3. Advanced filter in place
etc etc.

Thanks.
would like to explore the above 2 ways that you mentioned.

 

[cyliyu]

cyliyu
... depends how many 'flash' do You need and so on ... sample

Perhaps when the s/no and date code entered and the condition meets, flash it for 3 sec and stop to alert the end user.

I don't "see" any flashing in your uploaded file.

 

[vletm]

cyliyu
Perhaps You would REcheck when/what makes "Yes".
Nothing won't 'flash' if nothing won't trigger it!
( ... or did You check that file within those 3 secs?)

 

[cyliyu]

cyliyu
Perhaps You would REcheck when/what makes "Yes".
Nothing won't 'flash' if nothing won't trigger it!
( ... or did You check that file within those 3 secs?)

Thanks vletm.
Yes, it flashed twice at column "B" when s/no and date code entered.
Could you share with me how to do it as I do see any VBA coding?

 

[vletm]

As You notice that it 'flash',
then there is that code too.

 

[cyliyu]

Thanks vletm for the code.
Saw it, tested and it works, just that if the spreadsheet data getting huge, will see some "delay".

 

[vletm]

What kind of "delay" will see?
... like a msgbox "You got 'YES' in row NNNN",vbinformation,"DELAY"

 

[vletm]

cyliyu ... hmm?
... and if the spreadsheet data get huge then ...
it would use less less formulas.
> would this version of "delay" be better? <

 

[cyliyu]

cyliyu ... hmm?
... and if the spreadsheet data get huge then ...
it would use less less formulas.
> would this version of "delay" be better? <

amazing vletm, it helps.
Appreciate your help and fast response. Thanks.

 

[vletm]

Sometimes it would be good to get answers ...

 

[cyliyu]

Sometimes it would be good to get answers ...

Yes, it solved the "delay" issues. sorry to miss it in my last post replied.

 

[Eloise T]

Yes, it solved the "delay" issues. sorry to miss it in my last post replied.

I also did not see Column B flash. How exactly do you trigger it?

 

[cyliyu]

The row will only flash when the serial number and date code fall within the 3 months warranty.
You need to have the warranty sheet updated with the warranty record, when the same serial number input in the Database sheet, flashing will occurred if the serial number match in the warranty sheet and within 3 months.

 

[Eloise T]

Thank you.