Forum Discussion
Cause the row to cycle between to fill colors based on the content of a cell
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.
- VBA is acceptable. Can you provide a sample of the needed code or point me to somewhere I can learn how this would be done in VBA?