You have to use the Condition that determines the colour, not the actual colour. So if it all cells > 5 are red, then that is what you look for in the VBA - values > 5.