And I just used the blanks option in conditional formatting to stop blank cells going red. Thanks one and all for your help. Much appreciated.