Changing The Cell Color With A Certain Value Is Entered

    Looking for help with the following:


    I would like the cell to be red if the value is below 1.5. If the value is 1.5 or greater, I would like for that cell to turn green.



    Really appreciate your help.

    Re: Changing The Cell Color With A Certain Value Is Entered


    Select the cells you want this to happen in, then go to Format -> Conditional Format. You will need to apply two conditional formats (click the Add button after entering the first CF)

Participate now!

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

Register Yourself Login