Hi
I am looking for a code or formula that will allow me to count how many conditionally formatted cells are in a row and colour them accordingly, then reset to "0" when a particular word/colour is selected. Cells contain txt not numbers:
A1:A14
A1:A5 contain combination of either "Day", "Night", "Swing"(which are conditionally formatted to turn green)
First part is:
If these words/colours are consecutive in 1-6 cells they should remain green.
If these words/colours are consecutive from 1-10 cells then the first lot 1-6 should remain green, but the second lot 7-10 should turn orange.
If these words/colours are consecutive from 1-14 cells then the first lot 1-6 should remain green, the second lot 7-10 should turn orange and the last lot 11-14 should turn red. (we call this traffic light reporting as this gives an indication of when things are from good to caution to alert).
Second part is:
If the word "Rest" (which is set to be non coloured cell) then I would need the count to be reset to "0" and the process start from the next cell depending on the word/colour.
I hope I have made sense - any assistance would be much appreciated.
Kind regards
Sabrina78
Bookmarks