Conditional Formatting

[Stuart]

i need a formulae that will make conditional formatting do the following.

if column k has a value of 5 or more than column I in the corresponding row
will turn red unless there is a value in the corresponding cell in column J.

how can this be done?

--
Stuart

[Stefi]

If I understood well the verbal condition, apply this formula:
=AND(OR(K1=5,K1>I1),ISBLANK(A1))

Regards,
Stefi

„Stuart” ezt �*rta:

> i need a formulae that will make conditional formatting do the following.
>
> if column k has a value of 5 or more than column I in the corresponding row
> will turn red unless there is a value in the corresponding cell in column J.
>
> how can this be done?
>
> --
> Stuart

[Bryan Hessey]

Try the formula

=AND(K1>I1+4,J1="")

--

i need a formulae that will make conditional formatting do the following.

if column k has a value of 5 or more than column I in the corresponding row
will turn red unless there is a value in the corresponding cell in column J.

how can this be done?

--
Stuart

[Stuart]

no neitrher response seems to make sense when i read them, it should be
something along the lines of the following.

k8>4, J8>" "

however i don't know the correct syntax to acheive this outcome.
--
Stuart


"Bryan Hessey" wrote:

>
> Try the formula
>
> =AND(K1>I1+4,J1="")
>
> --
>
>
> Stuart Wrote:
> > i need a formulae that will make conditional formatting do the
> > following.
> >
> > if column k has a value of 5 or more than column I in the corresponding
> > row
> > will turn red unless there is a value in the corresponding cell in
> > column J.
> >
> > how can this be done?
> >
> > --
> > Stuart
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=540950
>
>

[Stefi]

Sorry, I mistyped the formula, the correct one is
=AND(OR(K1=5,K1>I1),ISBLANK(J1))

Stefi

„Stefi” ezt �*rta:

> If I understood well the verbal condition, apply this formula:
> =AND(OR(K1=5,K1>I1),ISBLANK(A1))
>
> Regards,
> Stefi
>
> „Stuart” ezt �*rta:
>
> > i need a formulae that will make conditional formatting do the following.
> >
> > if column k has a value of 5 or more than column I in the corresponding row
> > will turn red unless there is a value in the corresponding cell in column J.
> >
> > how can this be done?
> >
> > --
> > Stuart

[Stuart]

Stefi

i will try the formulae but i don't understand it. this is how i read it.

=AND(OR(K1=5,K1>I1),ISBLANK(J1))

k1 is = 5 or greater than I1. and theres a test to see if J1 is blank. now
the J1 test thats great but i don't need to know if K1 is greater than I1 i
just need to know if K1 is greater than 4.

i tested your formulae and it appears to work when configured as follows.

=AND(OR(K8=5,K8>5),ISBLANK(J8))

thanks for all your help i am most grateful.

--
Stuart


"Stefi" wrote:

> Sorry, I mistyped the formula, the correct one is
> =AND(OR(K1=5,K1>I1),ISBLANK(J1))
>
> Stefi
>
> „Stefi” ezt �*rta:
>
> > If I understood well the verbal condition, apply this formula:
> > =AND(OR(K1=5,K1>I1),ISBLANK(A1))
> >
> > Regards,
> > Stefi
> >
> > „Stuart” ezt �*rta:
> >
> > > i need a formulae that will make conditional formatting do the following.
> > >
> > > if column k has a value of 5 or more than column I in the corresponding row
> > > will turn red unless there is a value in the corresponding cell in column J.
> > >
> > > how can this be done?
> > >
> > > --
> > > Stuart

[Stefi]

Stuart,
your condition was
"if column k has a value of 5 or more than column I in the corresponding row"
In my interpretation in consist of two parts:
1.if column k has a value of 5: K1=5
2.or more than column I in the corresponding row: K1>I1

If the condition really is "K1 is greater than 4" then the formula is:
=AND(K1>4,ISBLANK(J1))

but in this case where is I1? This is another condition!
Sorry if misundersanding is caused by my poor English!

Stefi

„Stuart” ezt �*rta:

> Stefi
>
> i will try the formulae but i don't understand it. this is how i read it.
>
> =AND(OR(K1=5,K1>I1),ISBLANK(J1))
>
> k1 is = 5 or greater than I1. and theres a test to see if J1 is blank. now
> the J1 test thats great but i don't need to know if K1 is greater than I1 i
> just need to know if K1 is greater than 4.
>
> i tested your formulae and it appears to work when configured as follows.
>
> =AND(OR(K8=5,K8>5),ISBLANK(J8))
>
> thanks for all your help i am most grateful.
>
> --
> Stuart
>
>
> "Stefi" wrote:
>
> > Sorry, I mistyped the formula, the correct one is
> > =AND(OR(K1=5,K1>I1),ISBLANK(J1))
> >
> > Stefi
> >
> > „Stefi” ezt �*rta:
> >
> > > If I understood well the verbal condition, apply this formula:
> > > =AND(OR(K1=5,K1>I1),ISBLANK(A1))
> > >
> > > Regards,
> > > Stefi
> > >
> > > „Stuart” ezt �*rta:
> > >
> > > > i need a formulae that will make conditional formatting do the following.
> > > >
> > > > if column k has a value of 5 or more than column I in the corresponding row
> > > > will turn red unless there is a value in the corresponding cell in column J.
> > > >
> > > > how can this be done?
> > > >
> > > > --
> > > > Stuart

[[email protected]]

put this formula in cell I-8, then copy it down
=AND(K8>4.999,ISBLANK(J8)) I think your responses were mislead
because you used "than" instead of "then" in your first post.

ed

[Stuart]

thanks to stefi, edcosoft and everyone else that posted a reply to my
questions. i am greatfull to each and every one of you for your time and
patience in helping me with this. i look forward to seeing you guys here in
the future and if i can ever help you guys just let me know.
--
Stuart


"[email protected]" wrote:

> put this formula in cell I-8, then copy it down
> =AND(K8>4.999,ISBLANK(J8)) I think your responses were mislead
> because you used "than" instead of "then" in your first post.
>
> ed
>
>