Ok I have found the answer it is the same as previous versions, you can only circle invalid data where you set the validation to a maximum of 255, they still do not print out but you can use VBA code to get around this to circle all and then also print if needs be.