Highlight more than one entire row when cells = TRUE

[Mally]

Hi all

I can use conditional formatting to highlight a entire row but is it
possible to highlight more than one entire row at the same time.

e.g.

If cells A1, C1, F1, AB1 all = TRUE then these entire rows should be
highlighted.

Thanks

 

[Bob Phillips]

That is only one row, multiple columns, but one row.

Just select them all and use a formula of

=AND($A1=TRUE,$B1=$A1,$F1=$A1,$AB1=$A1)

 

[Mally]

Thanks Bob

Basically if any cells in column B for example contain TRUE then the
relevant entire row will be highlighted

Apolgies, I wrote the example incorrect. I should have stated

e.g.

A1, A2, A5, A17, A40 etc.

 

[Mike H]

Select the rows and use this conditional format

=$B1=TRUE

Where $B1 is the first row on the range.

Mike

 

[Mally]

It worked. Thanks for your help Mike.

Select the rows and use this conditional format

=$B1=TRUE

Where $B1 is the first row on the range.

Mike

 

[Mike H]

Glad I could help

It worked. Thanks for your help Mike.