Is there a way to color a row based on the value of a formula in one cell? Right now I just have row marked as a color using this rather simpleton formula: =IF(J3+K3>499,"Gold",(IF(J3+K3>299,"Silver",(IF(J3+K3>99,"Bronze",""))))) Would be better to color those rows instead.