Hi
I am running Excel 2008 on my MacBook Pro.
I'd like to conditionally format some cells in a single column with
a condition format like:
<COndition 1> AND <Condition 2> AND <Condition 3>
However, the (paltry) help seems to suggest that I can only
do a logical OR of the conditions. It says
" If more than one condition is true for a cell, Excel applies only the formatting of the first true condition to that cell."
Although that is a bit vague, I certainly can't get it to do logical
AND through the graphical interface.
Any cunning ideas ? Google has failed to find me the answer. Sniff.
Zag
I am running Excel 2008 on my MacBook Pro.
I'd like to conditionally format some cells in a single column with
a condition format like:
<COndition 1> AND <Condition 2> AND <Condition 3>
However, the (paltry) help seems to suggest that I can only
do a logical OR of the conditions. It says
" If more than one condition is true for a cell, Excel applies only the formatting of the first true condition to that cell."
Although that is a bit vague, I certainly can't get it to do logical
AND through the graphical interface.
Any cunning ideas ? Google has failed to find me the answer. Sniff.
Zag