Conditional formatting via formula

    Hi guys,


    How can I set conditional formatting to only highlight cells with less than 1 value.


    e.g. in example below. It will highlight the cell with -1 SNL, -10 SNL, -3 SNL, -5 SNL


    I tried =Left(A1,2)<1 but it didn't work.
    [TABLE="width: 500"]

    [tr]


    [td]

    -1 SNL

    [/td]


    [td]

    -10 SNL

    [/td]


    [/tr]


    [tr]


    [td]

    8 SNL

    [/td]


    [td]

    -3 SNL

    [/td]


    [/tr]


    [tr]


    [td]

    -5 SNL

    [/td]


    [td]

    5 SNL

    [/td]


    [/tr]


    [/TABLE]

    Re: Conditional formatting via formula


    Hi vkingw2k


    Try this but I haven't tested it, so no guarantees.


    =LEFT(A1,1)="-"

Participate now!

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

Register Yourself Login