Hello,
I am a newbie to doing anything beyond the basics in Excel so you might have to very specific in explanations. unfortunately I do not know VB (some Javascript & bash) and afraid what I am looking for will require it.
Thanks
Environment: Excel 2013
Current Workbook layout:
<tbody>
</tbody>
Explanation of columns:
A = a system name based on a dynamic list created from a tab called "master" > tbl_master
B = the parameter used to search against the object in the tbl_master
C - G = are filled via an INDEX formula against the tbl_master using the system name as the key
Final Result (what I am trying to accomplish [---- represents highlight or something similar]):
<tbody>
</tbody>
Explanation of "----" in rows 3, 6,7:
Any assistance is appreciated.
Thanks
B
I am a newbie to doing anything beyond the basics in Excel so you might have to very specific in explanations. unfortunately I do not know VB (some Javascript & bash) and afraid what I am looking for will require it.
Thanks
Environment: Excel 2013
Current Workbook layout:
A | B | C | D | E | F | G | |
1 | System | Voltage | RU | BTU | 110v | 208v | KG |
2 | computer1 | 208 | 2 | 1945 | 2.7 | 1.2 | 17 |
3 | |||||||
4 | computer2 | 208 | 1 | 780 | 1.4 | .7 | 7 |
5 | computer3 | 208 | 3 | 1000 | 3.0 | 1.5 | 11 |
6 | |||||||
7 |
<tbody>
</tbody>
Explanation of columns:
A = a system name based on a dynamic list created from a tab called "master" > tbl_master
B = the parameter used to search against the object in the tbl_master
C - G = are filled via an INDEX formula against the tbl_master using the system name as the key
Final Result (what I am trying to accomplish [---- represents highlight or something similar]):
A | B | C | D | E | F | G | |
1 | System | Voltage | RU | BTU | 110v | 208v | KG |
2 | computer1 | 208 | 2 | 1945 | 2.7 | 1.2 | 17 |
3 | ---- | ---- | ---- | ---- | ---- | ---- | ---- |
4 | computer2 | 208 | 1 | 780 | 1.4 | .7 | 7 |
5 | computer3 | 208 | 3 | 1000 | 3.0 | 1.5 | 11 |
6 | ---- | ---- | ---- | ---- | ---- | ---- | ---- |
7 | ---- | ---- | ---- | ---- | ---- | ---- | ---- |
<tbody>
</tbody>
Explanation of "----" in rows 3, 6,7:
- column C represents the amount of "U" in a computer rack
- Using the value in C, I would like to automatically fill in the rows with conditional format or symbols (something to indicate the blank space is actually occupied)
- E.g.
- if C = 1, no fill necessary
- if C = 2, fill in the row below with yellow
- if C = 3, fill in the next 2 rows below
- etc.....
Any assistance is appreciated.
Thanks
B