Conditional formatting - with multiple conditions

[kiwikiki718]

Hello is there a way to assign 3 conditions that must be true in order for a cell to turn a color.

Ex. If F5 is blank and F1 is not blank and F3 does not equal “Pass”

I want to be able to enter this formula as a new rule so that a cell will highlights if true.

How should that condition be created?

 

[awoohaw]

yes, in your conditional formatting formula use:

=AND(ISBLANK(F5),ISBLANK(F1)=FALSE,F3<>"PASS")

 

[Fluff]

Another option

=and(f5="",f1<>"",f3<>"Pass")

 

[kiwikiki718]

yes, in your conditional formatting formula use:

=AND(ISBLANK(F5),ISBLANK(F1)=FALSE,F3<>"PASS")

Thank u this worked but since F1 has a formula in it, it is making the statement false. Is there a way to indicate is not a number? Instead of is not blank for F1?

 

[Fluff]

Try the formula I posted, that is designed to work with cells that contain a formula.

 

[awoohaw]

Thank u this worked but since F1 has a formula in it, it is making the statement false. Is there a way to indicate is not a number? Instead of is not blank for F1?

i would have suggested the formula by Fluff but you said Blank. A formula is not Blank.