[Dba-office] conditional formatting in formulas

[Susan Harkins]

John, but the literal formula or the formula's result? 

Susan H. 


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.

 

_______________________________________________
Dba-office mailing list
Dba-office at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-office