Help: Excel expert

doggie750
doggie750 Posts: 1,160
edited October 2011 in The Clubhouse
Hello Polks,

It's been a while since I played with conditional formatting, I hope u guys can help me out on this. Basically I need to automate a cell between "OR" and "ORF". If the data on the adjacent cell is above 100000 then the cell reads "ORF" otherwise excel will pick "OR". If the # are entered first then it'll automate the OR or ORF. PLEASE advice. Your help is greatly appreciated.

OR 20495
ORF 100001



Cheers,
Edwin
Godspeed,
D0661E

AVR:Pioneer Elite SC-07
Surrounds: RTis
2channel:Rti100 (carver driven
Sub:SVS PB12-Plus/2
Dedicated AMPs:Adcom GFA535, 2xCarver 1.5t, Carver m1.0t
Wsrn:Hitachi ultra vision LCD60, 32XBR400
PowerConditioner: MonsterC HTS5100
PS3, Toshiba HD A2, etc: SonySACD/ Panasonic gears DIVX.

MR3LIGION: Polkaudio; GSXR; E46; Reeftank;
Odyclub; Xsimulator; Sony; Zune; Canon
Post edited by doggie750 on
· Share on FacebookShare on Twitter

Comments

  • CTTE
    CTTE Posts: 183
    edited October 2011
    Assuming column B is the numbers, and you have no column headings, here's the formula for cell A1:

    =IF(B1>100000,"ORF","OR")

    Then you can copy the formula down column A.
    · Share on FacebookShare on Twitter
  • Big Dawg
    Big Dawg Posts: 2,005
    edited October 2011
    If you saying that you want the neighboring cell to read either "OR" or "ORF," then you don't need conditional formatting, all you need is a simple if-then statement: =if(cellref>100000,"ORF","OR")
    · Share on FacebookShare on Twitter
  • Big Dawg
    Big Dawg Posts: 2,005
    edited October 2011
    damn, I was too slow....
    · Share on FacebookShare on Twitter
  • mufsoman
    mufsoman Posts: 631
    edited October 2011
    Doggie750 - there are several very good Excel forums that provide quick answers to any questions. Mrexcel is the one I use for my many Excel questions. Responses are very quick and helpfull.
    Parasound HCA-2003A & 2205A
    Front: Rti12's
    Center: Csi A6
    Side surrounds: Polk Rti A1's
    Atmos: Mirage Nanosats
    APC H15
    Power cords by Pepster, Morrow MA4 IC's, AQ Midnight, AQ Chocolate HDMI's[/SIZE]
    The rest is TBD.
    · Share on FacebookShare on Twitter
  • maximillian
    maximillian Posts: 2,144
    edited October 2011
    Well, he got 2 responses in less than 20 minutes. I think this is quite fast. I know there are "better" forums out there for non-audio related questions. However, many people know eachother here and trust their response. I just got some computer hardware help in another thread. As long as it's not a newbie asking across multiple forums, I think it's OK.
    · Share on FacebookShare on Twitter
  • doggie750
    doggie750 Posts: 1,160
    edited October 2011
    Grateful to ALL...........
    Godspeed,
    D0661E

    AVR:Pioneer Elite SC-07
    Surrounds: RTis
    2channel:Rti100 (carver driven
    Sub:SVS PB12-Plus/2
    Dedicated AMPs:Adcom GFA535, 2xCarver 1.5t, Carver m1.0t
    Wsrn:Hitachi ultra vision LCD60, 32XBR400
    PowerConditioner: MonsterC HTS5100
    PS3, Toshiba HD A2, etc: SonySACD/ Panasonic gears DIVX.

    MR3LIGION: Polkaudio; GSXR; E46; Reeftank;
    Odyclub; Xsimulator; Sony; Zune; Canon
    · Share on FacebookShare on Twitter