To view Resource Status colors in 3D View window, change the Color mode to Resource Status by either going to 3D View Properties > Color mode or Right-click on 3D View window > Color mode -