in datasheet view you need to use conditional formatting - either use vba in the form open or load event or in view mode, select conditional formatting from the ribbon.
Use some thing like
fieldvalue is not equal to 0 for numeric values
fieldvalue is not equal to "" for text values