Multiple Condition Formatting

G

Gerard Sanchez

Hi,

Can anyone help me on this:

=IF(AND(F65<>0,G59="SELECT CUSTOMER"),APPLY FORMATTING, DON'T APPLY
FORMATTING)

I have been exploring the Conditional Formatting in 2007 and I may be wrong
but I don't see a way to set a condition whereby two(2) logical conditions
must be met for it to apply the formatting.

Any ideas??
 
T

T. Valko

What cell do you want to format and based upon what conditions?

Maybe this based on your formula:

Conditional Formatting>Manage rules>New rule>Use a formula to determine
which cells to format

=AND(F65<>0,G59="SELECT CUSTOMER")

For the formatting to be applied a formula must return logical TRUE or
return *any* number other than 0.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditionnal formatting 1
Conditional Formatting - sensing font to highlight condition 1
Bug: Array formulas in conditional formatting ignored on XMLSpreadsheet load 2
Conditional Formatting on Multiple Worksheets 1
Conditional formatting in Excel_Strange behaviour 6
How do I apply Conditional Formatting to a range? 2
order of conditional formatting rules 2
Conditional Formatting Excel 2003 1

Top