| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highlight a row yellow if a cell contains TRUE | Excel Discussion (Misc queries) | |||
| i want to highlight entire row when selecting a cell in that row | Excel Discussion (Misc queries) | |||
| copy an entire row IF a statement is true | Excel Worksheet Functions | |||
| How do I highlight a formula result (IF statment=True) | Excel Worksheet Functions | |||
| Conditional Format to Highlight entire Row? | Excel Worksheet Functions | |||
Linear Mode
