I am tryng to create Conditional Formatting with 3 conditions.

1) If J3>0 then format J3 light blue and stop

But if all 3 of the following conditions are true then format J3 dark blue

1) H3="Yes" (this field with have a "Yes" or "No" in it)
2) J3=0 (blank cell with no text)
3) K3>1 (this cell will have a 0 or 1 or 2 or 3 etc.)

Thanks for your help!



I

In article <E3E074EA-3923-4C91-9DDF-(E-Mail Removed)>,
PFABA <(E-Mail Removed)> wrote:

> I am tryng to create Conditional Formatting with 3 conditions.
>
> 1) If J3>0 then format J3 light blue and stop
>
> But if all 3 of the following conditions are true then format J3 dark blue
>
> 1) H3="Yes" (this field with have a "Yes" or "No" in it)
> 2) J3=0 (blank cell with no text)
> 3) K3>1 (this cell will have a 0 or 1 or 2 or 3 etc.)

One way:

Select J3. Choose Format/Conditional Formatting...

CF1: Cell Value is greater than 0
Format1: <patterns>/<lt blue>

CF2: Formula is =AND(COUNTA(J3)=0, H3="Yes",K3>1)
Format2: <patterns>/<dk blue>

You're my hero! Thank you so much. It worked!

PFABA, Ontario



"JE McGimpsey" wrote:

> In article <E3E074EA-3923-4C91-9DDF-(E-Mail Removed)>,
> PFABA <(E-Mail Removed)> wrote:
>
> > I am tryng to create Conditional Formatting with 3 conditions.
> >
> > 1) If J3>0 then format J3 light blue and stop
> >
> > But if all 3 of the following conditions are true then format J3 dark blue
> >
> > 1) H3="Yes" (this field with have a "Yes" or "No" in it)
> > 2) J3=0 (blank cell with no text)
> > 3) K3>1 (this cell will have a 0 or 1 or 2 or 3 etc.)
>
> One way:
>
> Select J3. Choose Format/Conditional Formatting...
>
> CF1: Cell Value is greater than 0
> Format1: <patterns>/<lt blue>
>
> CF2: Formula is =AND(COUNTA(J3)=0, H3="Yes",K3>1)
> Format2: <patterns>/<dk blue>
>

The second conditional formatting rule could be:

=and(h3="yes",j3="",k3>1)



PFABA wrote:
>
> I am tryng to create Conditional Formatting with 3 conditions.
>
> 1) If J3>0 then format J3 light blue and stop
>
> But if all 3 of the following conditions are true then format J3 dark blue
>
> 1) H3="Yes" (this field with have a "Yes" or "No" in it)
> 2) J3=0 (blank cell with no text)
> 3) K3>1 (this cell will have a 0 or 1 or 2 or 3 etc.)
>
> Thanks for your help!
>
> I

--

Dave Peterson