I am trying to right an if statement that says if the average ranking is null then make it grey. Can I use conditional formatting?
It depends on exactly what you want to make grey. You can make the mark gray by creating a calculated field like this and putting it on the colors shelf:
IF ISNULL(AVG(ranking)) THEN "Grey" ELSE "Black" END
Retrieving data ...