Highlight more than one entire row when cells = TRUE
 

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

Highlight more than one entire row when cells = TRUE
 

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)

--
__________________________________
HTH

Bob

"Mally" wrote in message
...
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

Highlight more than one entire row when cells = TRUE
 

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.

"Bob Phillips" wrote:

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)

--
__________________________________
HTH

Bob

"Mally" wrote in message
...
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

Highlight more than one entire row when cells = TRUE
 

Select the rows and use this conditional format

=$B1=TRUE

Where $B1 is the first row on the range.

Mike

"Mally" wrote:

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.

"Bob Phillips" wrote:

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)

--
__________________________________
HTH

Bob

"Mally" wrote in message
...
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

Highlight more than one entire row when cells = TRUE
 

It worked. Thanks for your help Mike.

"Mike H" wrote:

Select the rows and use this conditional format

=$B1=TRUE

Where $B1 is the first row on the range.

Mike

"Mally" wrote:

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.

"Bob Phillips" wrote:

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)

--
__________________________________
HTH

Bob

"Mally" wrote in message
...
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

Highlight more than one entire row when cells = TRUE
 

Glad I could help

"Mally" wrote:

It worked. Thanks for your help Mike.

"Mike H" wrote:

Select the rows and use this conditional format

=$B1=TRUE

Where $B1 is the first row on the range.

Mike

"Mally" wrote:

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.

"Bob Phillips" wrote:

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)

--
__________________________________
HTH

Bob

"Mally" wrote in message
...
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