I have a sheet filled with numbers from A1:IA500
Some of those cells have a red interiorcolor.
If there are FIVE cells in a row with this red color,I want to change the color in yellow,if they are not FIVE the color stays red.
Can someone give me a macro to do this?
Thanks
Some of those cells have a red interiorcolor.
If there are FIVE cells in a row with this red color,I want to change the color in yellow,if they are not FIVE the color stays red.
Can someone give me a macro to do this?
Thanks