Can conditionformats be used for checking null or 0 value ?
Depending on the DataType. yes. A string cannot do a null check unless you create a custom format for it currently (there is an example of this in the forums), but all your numeric filters can format on zero