Forum Discussion
Cause the row to cycle between to fill colors based on the content of a cell
I am using Office 365 locally installed.
I want to format a row based on the contents of one cell. The twist is that I would like the fill color to alternate between 2 colors repeatedly for a given time.
The plan is that when incorrect data is detected, the row "Flashes" and gets the user's attention.
I know I can use conditional formatting to change the color once, that's not what I want. It needs to cycle the colors.
For example, If I have data in a3-d3, If d3="ERROR SEEK ASSISTANCE", then trigger alternating colors.
Unfortunately i didn't understand what you want to do when i first replied. Alternating change of colors for a certain time can be done only with VBA not with formulas.
=$D4="ERROR SEEK ASSISTANCE"You can apply the rule for conditional formatting for two different ranges and formats.
=$B$4:$B$25;$D$4:$D$25=$A$4:$A$25;$C$4:$C$25These are the ranges the format applies to in the example.
Ok, I didn't explain that very well. Let me try again.
I am trying to get the entire row to change colors, then a moment later, the entire row should change to another color. This should repeat for a predetermined amount of time, then stop cycling.
In effect, it should flash (Blink?) red then yellow then red then yellow and so on.
Is this possible?
Unfortunately i didn't understand what you want to do when i first replied. Alternating change of colors for a certain time can be done only with VBA not with formulas.
