• Your thread title gives no idea what you are asking. In fact your title itself is not clear.

    Maybe you need to use Conditional Formatting

    Use conditional formatting to highlight information

  • Respected Sir ,

    PRACTICAL: The issue is that when the levels in the upper reservoir is too much it is released in the lower reservoir , now normallly it is happening that this release is sometimes more than the capacity the lower reservoir can hold(and the structure is endangered).

    The solution I am trying: to monitor level of the reservoir so that difference(range between the opening and closing) is spotted.

    when the extra level is released from upper reservoir, a step-by-step movement has to be done so that immense flow does not come to lower reservoir which it can handle. So am trying to monitor (daily levels are updated every 4 hours , so 6 in a day). And similar step-by step can be released further.

    And the SECOND case is that if the increaseing levels is spotted in above feeder, lower feeder levels decreased pre-emptively to make way for the incoming future flow.

    OB-Overflow build up is spotted only after 3rd reading as it is normal that levels increase or decrease in normal flow. but 3rd consequence of it do trigger the situation. OB#, OB$, OB5, OB6 do mention that and when the OVERFLOW BUILDUP is released to lower reservoirs, it is flagger by OR

    ORA is flagging of abnormal levels seen(in lower reservoirs) if only one or two reading is too much fluctuating (due to OR from upper reservoir)



    • range.xlsx

      (13.23 kB, downloaded 79 times, last: )
  • sir, the total excel file is of 1.3 GB and I have tried using conditional formatting previously but it has slowed even the normal pageup/down thing tremendously. I am looking for logic of this , then I have to convert it to workable formulas in 14 files(each having 8 instances)


    Zohar Batterywala