Multiple Condition Formatting

  • Thread starter Thread starter Gerard Sanchez
  • Start date Start date
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??
 
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.
 
Back
Top