IF(AND()) Function with Three Conditions

[kripat-96]

Hi, I'm currently trying to create a rule for conditional formatting, where I want it to only activate when ALL 3 of the following conditions are satisfied.

1). Cell $A3 does not contain nothing

2). Cell $G3 is not TRUE

3). Cell $H3 does contain nothing

Note: condition 2). refers to a checkbox being ticked

=IF(AND($A3<>"",$G3<>TRUE,$H3=""),"TRUE","FALSE")

I have tried the formula above, however the problem I am having is that they activate even if two of the three conditions are met.

Is there any formula that could make this work? Kind Regards.

[AliGW]

Impossible to say without seeing the workbook. Where the formula is not working as expected, use the evaluate formula feature to step through it to find out where it is failing. Attach the workbook here if you want someone to take a look.

By the way, you can use this instead:

=IF(AND($A3<>"",$G3<>TRUE,$H3=""),TRUE,FALSE)

[shg]

Try just

=AND($A3<>"",$G3<>TRUE,$H3="")

[kripat-96]

Hi, thanks for the replies,
I have tried =AND($A3<>"",$G3<>TRUE,$H3="") but that also activates on either of the functions
I've attached a sample of the spreadsheet

https://mega.nz/#!oNNykRJT!ENSB2Ww4X...HzjwRpQRRUo1TE

Note: I had to upload to Mega because of file size restrictions

To clarify, I would like the row to become un-highlighted, when "Contract Review" is ticked, and any value is entered for "Order No"

Kind Regards