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.
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?
Here is a link to VBA code which should do what you are looking for.
- well that never appeared in any of my searches. Thank you so much. I will try it out later today.