[Dba-office] conditional formatting in formulas

John R Bartow jbartow at winhaven.net
Mon Jul 11 23:00:44 CDT 2016


Oddity appeared when I added one more formatting rule for the < 100. It
would not format the entire data range. So I tried > 0 and it changed what
it wouldn't format. Weird.

-----Original Message-----
From: Dba-office [mailto:dba-office-bounces at databaseadvisors.com] On Behalf
Of John R Bartow
Sent: Monday, July 11, 2016 9:33 PM
To: stuart at lexacorp.com.pg; dba-office at databaseadvisors.com
Subject: Re: [Dba-office] conditional formatting in formulas
Importance: High

OK, this did the trick once I got the hang of it. Nice solution, thanks
again.

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


1. Select cell  A3.
2. Home - Conditional Formatting - Manage Rules 3. Create new rule = "Use a
formula"
4. Set the formula to " = (($J3+$K3) > 499)"
5. Set the colour to gold.
6. Save the rule.
7. Select it
8. Click on the selector  beside "Applies to"
9. Ctrl Ato select the whole sheet.
10. Enter.
11. Hit Apply.
12. Repeat steps 3 to 11 for the other two colours.



On 7 Jul 2016 at 21:50, John R Bartow wrote:

> 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

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



More information about the Dba-office mailing list