in range type: 1,2,1,-2,0,1,2,2,1,0 all < 3 you will see red. if any of cells will be empty range will lost color. if any of values willl be < 3 - range will lost color. enough ONE cell with number >=3 or ONE empty cell to clear range from color.
but basically you did not tell what exactly you want to achieve
Bookmarks