software

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

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

Regards,
Stefi

?tuart??ezt ?rta:

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


Try the formula

=AND(K1gt;I1 4,J1=quot;quot;)

--Stuart Wrote:
gt; i need a formulae that will make conditional formatting do the
gt; following.
gt;
gt; if column k has a value of 5 or more than column I in the corresponding
gt; row
gt; will turn red unless there is a value in the corresponding cell in
gt; column J.
gt;
gt; how can this be done?
gt;
gt; --
gt; Stuart--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=540950no neitrher response seems to make sense when i read them, it should be
something along the lines of the following.

k8gt;4, J8gt;quot; quot;

however i don't know the correct syntax to acheive this outcome.
--
Stuartquot;Bryan Hesseyquot; wrote:

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

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

Stefi

?tefi??ezt ?rta:

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

Stefi

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

=AND(OR(K1=5,K1gt;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,K8gt;5),ISBLANK(J8))

thanks for all your help i am most grateful.

--
Stuartquot;Stefiquot; wrote:

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

Stuart,
your condition was
quot;if column k has a value of 5 or more than column I in the corresponding rowquot;
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: K1gt;I1

If the condition really is quot;K1 is greater than 4quot; then the formula is:
=AND(K1gt;4,ISBLANK(J1))

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

Stefi

?tuart??ezt ?rta:

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

put this formula in cell I-8, then copy it down
=AND(K8gt;4.999,ISBLANK(J8)) I think your responses were mislead
because you used quot;thanquot; instead of quot;thenquot; in your first post.

edthanks 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.
--
Stuartquot; wrote:

gt; put this formula in cell I-8, then copy it down
gt; =AND(K8gt;4.999,ISBLANK(J8)) I think your responses were mislead
gt; because you used quot;thanquot; instead of quot;thenquot; in your first post.
gt;
gt; ed
gt;
gt;