Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format - using 3 different cells conditions together
I need a example of how to do this... to check conditions of other cells CF
conditions. In cell A1 - In the "Conditional Format" section "Condition 1" Result (needes to be "True") In cell B1 - In the "Conditional Format" section "Condition 2" Result (needs to be "False") In cell C1 - In the "Conditional Format" section "Condition 3" Result (needs to be "True") In cell D1 In the "Conditional Format" section "Condition 1" Result needs to check all (3 above) Conditions from cell A1, B2, & C3 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format - using 3 different cells conditions together
Just use =AND(...) or =OR(...) in your CF/ Formula Is/ condition to combine
your conditions as you require. -- David Biddulph j5b9721 wrote: I need a example of how to do this... to check conditions of other cells CF conditions. In cell A1 - In the "Conditional Format" section "Condition 1" Result (needes to be "True") In cell B1 - In the "Conditional Format" section "Condition 2" Result (needs to be "False") In cell C1 - In the "Conditional Format" section "Condition 3" Result (needs to be "True") In cell D1 In the "Conditional Format" section "Condition 1" Result needs to check all (3 above) Conditions from cell A1, B2, & C3 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format - using 3 different cells conditions together
Select "Formula is", and then input something like:
=AND(Condition1FromA1,NOT(Condition2FromB2),Condit ion3FromC1) Fill in the Condition that you used in the other cells as appropriate. Also, I'm guessing you got the "error with posting thread message", but try to to multi-post (you've got 5 threads!) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "j5b9721" wrote: I need a example of how to do this... to check conditions of other cells CF conditions. In cell A1 - In the "Conditional Format" section "Condition 1" Result (needes to be "True") In cell B1 - In the "Conditional Format" section "Condition 2" Result (needs to be "False") In cell C1 - In the "Conditional Format" section "Condition 3" Result (needs to be "True") In cell D1 In the "Conditional Format" section "Condition 1" Result needs to check all (3 above) Conditions from cell A1, B2, & C3 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format - using 3 different cells conditions togeth
Hi David...
The string I am using is to long for CF to use. It wont even copy to the "formula is" location. So I figured to try and use it in this fashon. "David Biddulph" wrote: Just use =AND(...) or =OR(...) in your CF/ Formula Is/ condition to combine your conditions as you require. -- David Biddulph j5b9721 wrote: I need a example of how to do this... to check conditions of other cells CF conditions. In cell A1 - In the "Conditional Format" section "Condition 1" Result (needes to be "True") In cell B1 - In the "Conditional Format" section "Condition 2" Result (needs to be "False") In cell C1 - In the "Conditional Format" section "Condition 3" Result (needs to be "True") In cell D1 In the "Conditional Format" section "Condition 1" Result needs to check all (3 above) Conditions from cell A1, B2, & C3 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format - using 3 different cells conditions togeth
Hi Luke...
I tried it just the way you shown me, (and others too) but nothing worked... using a very simple command. In cell EU101 "cf cond 1 & cond 2" I entered cond 1 =$EU$1014 for green fill cond 2 =$EU$101<3 for red fill in cell EV101 I entered... (a few different ways) =(Condition2FromEU101) =AND($EV$101<3,Condition2FromEU101) =IF($EV$101<3,Condition2FromEU101,Condition1FromEU 101) I even tried adding commas, dashes, semicolons, to all 3 but nothing worked. "Luke M" wrote: Select "Formula is", and then input something like: =AND(Condition1FromA1,NOT(Condition2FromB2),Condit ion3FromC1) Fill in the Condition that you used in the other cells as appropriate. Also, I'm guessing you got the "error with posting thread message", but try to to multi-post (you've got 5 threads!) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "j5b9721" wrote: I need a example of how to do this... to check conditions of other cells CF conditions. In cell A1 - In the "Conditional Format" section "Condition 1" Result (needes to be "True") In cell B1 - In the "Conditional Format" section "Condition 2" Result (needs to be "False") In cell C1 - In the "Conditional Format" section "Condition 3" Result (needs to be "True") In cell D1 In the "Conditional Format" section "Condition 1" Result needs to check all (3 above) Conditions from cell A1, B2, & C3 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format - using 3 different cells conditions togeth
I was having trouble adding the post, would you believe I had tried about 30
times to get it through. "Luke M" wrote: Select "Formula is", and then input something like: =AND(Condition1FromA1,NOT(Condition2FromB2),Condit ion3FromC1) Fill in the Condition that you used in the other cells as appropriate. Also, I'm guessing you got the "error with posting thread message", but try to to multi-post (you've got 5 threads!) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "j5b9721" wrote: I need a example of how to do this... to check conditions of other cells CF conditions. In cell A1 - In the "Conditional Format" section "Condition 1" Result (needes to be "True") In cell B1 - In the "Conditional Format" section "Condition 2" Result (needs to be "False") In cell C1 - In the "Conditional Format" section "Condition 3" Result (needs to be "True") In cell D1 In the "Conditional Format" section "Condition 1" Result needs to check all (3 above) Conditions from cell A1, B2, & C3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format Font Color for more than 3 conditions | Excel Worksheet Functions | |||
Conditional Format--2 conditions need to be true | Excel Worksheet Functions | |||
conditional format with 3 conditions | Excel Worksheet Functions | |||
Conditional Format - 3 conditions | Excel Worksheet Functions | |||
more conditional format conditions | Excel Worksheet Functions |