[Dba-office] conditional formatting in formulas

John R Bartow jbartow at winhaven.net
Mon Jul 11 21:18:25 CDT 2016


The result of the formula or maybe better than that, the actual number
values which the formula is evaluating.

-----Original Message-----
From: Dba-office [mailto:dba-office-bounces at databaseadvisors.com] On Behalf
Of Susan Harkins
Sent: Friday, July 08, 2016 6:47 AM
To: dba-office at databaseadvisors.com
Subject: Re: [Dba-office] conditional formatting in formulas

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

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



More information about the Dba-office mailing list