Forum Discussion
Solved
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 ...
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.
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.