[Dba-office] conditional formatting in formulas

[Stuart McLachlan]

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
>