# 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

Hi,

In G11,

=LOOKUP(H11,{-9.999E+307,0,1},{"Short","In Balance","Over"})

HTH

• 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!