Forum Discussion

Bontcho's avatar
Bontcho
Copper Contributor
Mar 01, 2019

Formulas

Hi I am new to excel as I have recently started a new job so this may be a simple one to answer. I need to create a table which will have 3 columns, START OF WORK AREA, END OF WORK AREA, AND OVERHEAD...
Excel
Twifoo's avatar
Twifoo
Silver Contributor
In your example, what will the Overhead Cables column list? Please elaborate.
Twifoo's avatar
Twifoo
Silver Contributor
Mar 01, 2019
Given the start and end of the work areas, how do you determine the work areas between them and which work area is dangerous?
  • Bontcho's avatar
    Bontcho
    Copper Contributor
    Mar 01, 2019
    The work are is the whole area between start and end. And I wanted the condition set so if any of the dangerous locations are inbetween the range they will come up in separate column highlighted in red. The work location will be changed daily so all the dangerous locations I will need in the formula or conditional format so as the work area changes only the dangerous locations in the new range are highlighted.
    • Twifoo's avatar
      Twifoo
      Silver Contributor
      Mar 01, 2019
      It seems you already have a given list of dangerous locations and you want to highlight such dangerous locations that are between the start and end work areas. Is that what you want to achieve?
      • Bontcho's avatar
        Bontcho
        Copper Contributor
        Mar 01, 2019
        Yes that's what I require. Just not sure how. Thanks