If formula excel

    Hello can anyone help, im trying to figure out a formula for this, lets say i have worksheet A and B, if the value in column A worksheet A equal to the value in column A worksheet B, then the result will be "TRUE" in column B worksheet B. BUT if the value is NOT EQUAL the result will be "FALSE" in red color. what formula should i put in column B worksheet B ?

    What exactly do you mean?


    WSA A1 = WSB A1


    Or do you mean that WSA A1 appears somewhere in WSB column A?


    The colour can't be done with a regular formula. You'll need conditional formatting (on the Home ribbon) for that.

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

    sorry for the lack of information. let me illustrate:


    . ........WS1................ . WS2
    ============ ============
    .. A ......B ....C. . . .A ......B ........C
    --------------------- ---------------------
    1 x ....100........ 8 ..z.... 700 ....FALSE
    2 y .....200. . ....9 ..r..... 600
    3 z ......300... . 10 .x.... 100 ....TRUE


    nb. 1-2-3-8-9-10 is a #cell


    i wonder if its using vlookup formula?

    Try:


    =ISNUMBER(MATCH(A2,'WS1'!A:A,0))


    copied down


    To colour the FALSE, you need to conditional format for "cell value =" "=FALSE"

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

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

Register Yourself Login