Groups

    Techy Help: IF Statements in Excel

    Need a little help guys.

    trying to insert a "IF" statement into my worksheet.

    IF CELL X = P, then CELL Y = YES, OTHEWISE = NO

    but it seems displaying #name, and i dunno whats up!

    It is also possible, to colour cells A-C when Cell Y displays YES!?

    28 Comments

    For the first one, I guess you put the formula in cell Y, something along the lines of =IF(A1=P, "YES", "NO")
    (I assume the No was meant to be in Y as well?)
    where A1 is your cell X

    For the second one, check out conditional formatting (under the format window) - it may be able to do what you want to do.

    =IF(cellX=P,"yes","no") the formula would be wriiten in Cell Y

    choc1969;3704182

    =IF(cellX=P,"yes","no") the formula would be wriiten in Cell Y



    you will need to put the p in "P"

    conditional formatting for the second one, need any help ask.

    Original Poster

    greg_68;3704222

    you will need to put the p in "P"conditional formatting for the second … you will need to put the p in "P"conditional formatting for the second one, need any help ask.



    would it be easier if i sent you the excel file (its on 07 format but can save in 03)

    Banned

    Yh conditional formattin for the YES colour change


    can send to me too and I can sort out tomoz

    In 2003

    Highlight cells>Format>Conditional formatting>Cell Value is> Equal to> yes

    Format(in pop up)>patterns>yellow>ok>ok

    Original Poster

    i got the first part working, now for the colour

    Disco;3704462

    now, the cell where P needs it go, is BL57 AND BM57 MERGED together, does … now, the cell where P needs it go, is BL57 AND BM57 MERGED together, does that matter?



    have you sent Greg your spreadsheet ? :?

    Banned

    Merged cells mate you refer to the first cell in the code

    Original Poster

    choc1969;3704497

    have you sent Greg your spreadsheet ? :?



    YEA, WHY?

    no real date on as the mo, so its ok

    its quite hard to work out, but i think im gettting there

    Disco;3704619

    YEA, WHY?no real date on as the mo, so its okits quite hard to work out, … YEA, WHY?no real date on as the mo, so its okits quite hard to work out, but i think im gettting there



    I can't sleep at the mo and would have sorted it tonight for you, but am sure Greg will sort it or ODB. both of them helpful

    all takes practice, I play with it every day but forget the silliest of things....ie the missing speechmarks for the p in your formula

    good luck with your studies :thumbsup:

    Choc & ODB, think it's sorted but think there maybe more instalments as with most excel projects.

    I'm off now so Choc can help if you are staying up.

    no probs hun, give us a shout when needed

    Original Poster

    greg_68;3704662

    Choc & ODB, think it's sorted but think there maybe more instalments as … Choc & ODB, think it's sorted but think there maybe more instalments as with most excel projects.I'm off now so Choc can help if you are staying up.



    you sending me the file back over mate? rep will be added once I get my head around it

    right guys, conditional format kinda works in that, I want 8 cells coloured, but only 1 is doing so

    Disco;3704732

    you sending me the file back over mate? rep will be added once I get my … you sending me the file back over mate? rep will be added once I get my head around itright guys, conditional format kinda works in that, I want 8 cells coloured, but only 1 is doing so



    Did you get the file back, sent it about 25 minutes ago.

    Disco;3704732

    you sending me the file back over mate? rep will be added once I get my … you sending me the file back over mate? rep will be added once I get my head around itright guys, conditional format kinda works in that, I want 8 cells coloured, but only 1 is doing so



    you need to copy the format into all of the cells with the formula in

    Original Poster

    choc1969;3704893

    you need to copy the format into all of the cells with the formula in



    nar, i dont, look

    http://img242.imageshack.us/img242/3316/formatzv1.jpg


    I put the P in the bttm right corner, but I want the rest of that section to me the same colour, but it wont let me

    pm'd ya

    Original Poster

    greg_68;3704978

    pm'd ya



    brill, now explain who you do it lol please! thats perfect! :thumbsup::thumbsup::thumbsup:

    Disco;3704964

    nar, i dont, look]I put the P in the bttm right corner, but I want the … nar, i dont, look]I put the P in the bttm right corner, but I want the rest of that section to me the same colour, but it wont let me



    do you want the cell shading to be pink too......you can just format the fill colour :?

    highlight the cells that change colour and follow the instructions in earlier post on how to conditional format. This will show you how i did it.

    click on the p cell to see the formula for that.

    Gotta go to bed now, will catch up tomorrow mornin if you still need help.

    Original Poster

    choc1969;3704998

    do you want the cell shading to be pink too......you can just format the … do you want the cell shading to be pink too......you can just format the fill colour :?



    nar, greg as the idea. now i just need to know how do to it. many thanks to you all who gave assistance. I'm sure I'll be back before the end of the project.

    Im hoping to have a front screen button type thing, which would save me click the numerous tabs im want to add :whistling:

    Original Poster

    greg_68;3705004

    highlight the cells that change colour and follow the instructions in … highlight the cells that change colour and follow the instructions in earlier post on how to conditional format. This will show you how i did it.click on the p cell to see the formula for that.Gotta go to bed now, will catch up tomorrow mornin if you still need help.



    hang on mate... i click on P but theres no formula? ;-)

    Disco;3705019

    hang on mate... i click on P but theres no formula? ;-)



    sorry not the p, the paid/unpaid cell

    Original Poster

    greg_68;3705022

    sorry not the p, the paid/unpaid cell



    just give =IF(BL59="P","paid","unpaid") but not formatting? anyhoo its ok, off 2 bed so will crack on with it later.. cheers for help so far!

    Original Poster

    Greg, if i send you the master sheet can you do the whole sheet for me and send it back please..

    theres like 52 times it needs doing (ie: 52 weeks of the year) is it timetaking or what?

    i tried looking at the formula but cant see it. I need to undertstand it though incase i need to alter the sheet

    Original Poster

    greg, where we at with this mate.

    Original Poster

    any joy Greg?
    Post a comment
    Avatar
    @
      Text
      Top Discussions
      1. Find out how good your GP surgery is55
      2. Microsoft Gamescom - Possibly more free games / Project Scorpio711
      3. The HUKD Student Discount code sharing thread (most codes on Unidays are si…6541246
      4. What do you feel like whinging about today?1917259

      See more discussions