If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|