This thread is regarding how format a color on a cell in a map of a building I drew in excel.
In my map, each square foot in the facility corresponded to a cell in excel. For instance, the spot right by a door in the building might be "FA 130," where FA indicates the column and "130" indicates the row.
Now I need to be able to use conditional formatting to change the color of the cell in my map based on a result.
For example, my spreadsheet would read:
<tbody>
</tbody>
Then, on my map I would want "FA 130" to show up red and "BP 252" to show up green.
Any ideas how I might be able to accomplish this?
In my map, each square foot in the facility corresponded to a cell in excel. For instance, the spot right by a door in the building might be "FA 130," where FA indicates the column and "130" indicates the row.
Now I need to be able to use conditional formatting to change the color of the cell in my map based on a result.
For example, my spreadsheet would read:
Column | Row | Result |
FA | 130 | Negative |
BP | 252 | Positive |
<tbody>
</tbody>
Then, on my map I would want "FA 130" to show up red and "BP 252" to show up green.
Any ideas how I might be able to accomplish this?