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
|