Excel 2008 condition formatting

Z

zaggle

Registered
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
 
oh as always, post a question, work out the answer 1 minute later...

I believe I can format on a formula for the cells and that can be as complex
as I like


Zag
 
You must log in or register to reply here.
Back
Top