Is it possible to use more than two condition in conidtional formatting

[manish.agrawal446@gmail.com]

Is it possible to use more than two condition in conidtional formatting

for eg =and(=$H2="test",$I2="fail",$T2="Study")


this is not working . Please suggest me the format

 

[Hui]

Yes

It would be more like:

=And($H2="test",$I2="fail",$T2="Study")

all have to be correct for the condition to trigger


If you want one of the 3 conditions to trigger the CF use:

=Or($H2="test",$I2="fail",$T2="Study")

 

[manish.agrawal446@gmail.com]

Hi,

I tried with =and(=$H2="test",$I2="fail",$T2="Study") but didn't get any output

 

[Luke M]

As Hui's post showed, you have an extra "=" in your formula.

Good:

=And($H2="test",$I2="fail",$T2="Study")

Bad:

=And(=$H2="test",$I2="fail",$T2="Study")


All 3 conditions must be met for CF to be triggered.