I'm attempting shade cells using the conditional formatting option.
The conditions I am using are as follows...
If cell X is greater than cell T then shade green.
If cell X is less than cell T then shade red.
If cell X is equal to cell T then shade blue.

These conditions have been applied to a particular column.

The issue is that if the cell has no value at all it shades red. I do not
want this to happen as data has not yet been gathered for this cell.

Any solutions or ideas?