The code i have below works fine if the cell is empty (has had nothing entered into it and has not been editted):
If Range(sRange).Text <> "" Then
Range(sRange).Interior.ColorIndex = iColour
But if there is a 'SPACE' (i.e. someone has pressed the spacebar inside the cell) or multiple spaces inside the cell then it colours it as it sees it as NOT EMPTY. How can i get around this? What code can i add into my if statement that i have posted above?