# [Dba-office] conditional formatting in formulas

Susan Harkins ssharkins at gmail.com
Tue Jul 12 06:35:31 CDT 2016

```So this
=IF(J3+K3>499,"Gold",(IF(J3+K3>299,"Silver",(IF(J3+K3>99,"Bronze","")))))
means:

1.) If J3+K3>499 range is gold
2.) If J3+K3>200 range is silver
3.) If J3+K3>99 range is bronze

The trick is to get the conditional rules in the right order because all
three rules can apply to the same value.

So, you select the range you want highlighted, click Conditional Formatting,
choose New Rule, choose the Formula option in the top pane, and enter the
formula

=\$J3+\$K3>99

Click Format, choose the color, Ok yourself out.

Repeat using the formulas

=\$J3+\$K3>200

=\$J3+\$K3>499

I'll send you a sample sheet.

Susan H.

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

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
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 mailing list