Conditional Format - using 3 different cells conditions together

  • Thread starter Thread starter j5b9721
  • Start date Start date
J

j5b9721

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
 
Select "Formula is", and then input something like:

=AND(Condition1FromA1,NOT(Condition2FromB2),Condition3FromC1)

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!)
 
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.
 
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$101>4 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,Condition1FromEU101)

I even tried adding commas, dashes, semicolons, to all 3 but nothing worked.
 
I was having trouble adding the post, would you believe I had tried about 30
times to get it through.
 
Back
Top