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
|