[Dba-office] conditional formatting in formulas

John R Bartow jbartow at winhaven.net
Thu Jul 7 21:50:46 CDT 2016


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.

 



More information about the Dba-office mailing list