[Dba-office] conditional formatting in formulas
John R Bartow
jbartow at winhaven.net
Mon Jul 11 21:33:26 CDT 2016
OK, this did the trick once I got the hang of it. Nice solution, thanks
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
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.
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
> Right now I just have row marked as a color using this rather
> simpleton formula:
> Would be better to color those rows instead.
> Dba-office mailing list
> Dba-office at databaseadvisors.com
Dba-office mailing list
Dba-office at databaseadvisors.com
More information about the Dba-office