IF/OR Usage to format cells based on given value in any set of columns

[Thanhpi]

Hi,

I want to format the A column depending on the data in I J and K column

so i could make 3 different Formatting rules

=$I1="True"

But what if i want to do I J and K in the same formatting rule?


Sorry if its a bit unclear

 

[Special-K99]

Not worded very well.

You want to say if I J or K are TRUE?

=OR($I1="TRUE",$J1="TRUE",$K1="TRUE)

 

[Thanhpi]

Thanks alot for the answer, have a good weekend!