Conditional Formatting

[Guest]

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?

 

[Guest]

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

Regards,
Stefi

„Stuart†ezt írta:

 

[Bryan Hessey]

Try the formula

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

--

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

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

how can this be done?

 

[Guest]

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.

 

[Guest]

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

Stefi

„Stefi†ezt írta:

 

[Guest]

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.

 

[Guest]

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:

 

[edcosoft]

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

 

[Guest]

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.