Conditional Formatting
 

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

Conditional Formatting
 

If I understood well the verbal condition, apply this formula:
=AND(OR(K1=5,K1I1),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

Conditional Formatting
 

Try the formula

=AND(K1I1+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

Conditional Formatting
 

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

k84, J8" "

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


"Bryan Hessey" wrote:


Try the formula

=AND(K1I1+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

Conditional Formatting
 

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

Stefi

€žStefi€� ezt Ã*rta:

If I understood well the verbal condition, apply this formula:
=AND(OR(K1=5,K1I1),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

Conditional Formatting
 

Stefi

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

=AND(OR(K1=5,K1I1),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,K85),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,K1I1),ISBLANK(J1))

Stefi

€žStefi€� ezt Ã*rta:

If I understood well the verbal condition, apply this formula:
=AND(OR(K1=5,K1I1),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

Conditional Formatting
 

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: K1I1

If the condition really is "K1 is greater than 4" then the formula is:
=AND(K14,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,K1I1),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,K85),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,K1I1),ISBLANK(J1))

Stefi

€žStefi€� ezt Ã*rta:

If I understood well the verbal condition, apply this formula:
=AND(OR(K1=5,K1I1),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

Conditional Formatting
 

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

ed

Conditional Formatting
 

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


" wrote:

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

ed