Conditional formatting in an adjacent cell

  • I am creating a drawer balance sheet for a business. I have one cell, lets assume it is "H11", that will have three conditions which are: 1. greater than zero, 2. equal to zero, and 3. less than zero. What I want to accomplish is I want to have cell "G11" to display different text depending on the condition of h11. For example if H11 is greater that 0 I want G11 to display OVER. If H11 is equal to zero I want G11 to display IN BALANCE. and if H11 is less than zero I want G11 to display SHORT. Any help would be greatly appreciated.


    Thanks
    jledlow

  • Re: Conditional formatting in an adjacent cell


    Thanks Krishnakumar.
    I tried the formula and it does exactly what I need. Since I am still in the learning of these more complex formulas, could you explain how the above formula accomplishes the results. I've always been one to ask questions when I want to know how something works.


    Thanks again for helping.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!