Results 1 to 7 of 7

Thread: Microsoft excel....help!

  1. #1
    Senior Member
    Join Date
    Feb 2008
    Posts
    326
    Thanks
    38
    Thanked
    15 times in 13 posts
    • Krakkenbus's system
      • Motherboard:
      • MSI P55-GD65
      • CPU:
      • i5 750 @ 3.4GHz
      • Memory:
      • 8GB G.skill Ripjaw
      • Storage:
      • 6TB+
      • Graphics card(s):
      • 2GB 6950
      • PSU:
      • Enermax Liberty 620W
      • Case:
      • Coolermaster Cosmos
      • Operating System:
      • 7 Ultimate 64bit
      • Monitor(s):
      • 2xSamsung 22"
      • Internet:
      • FTTC @ 50 Mb/s

    Microsoft excel....help!

    I've been asked to design a spreadsheet in work, basically I need a cell to be green if the percentage is say over 10% and for it to be red when it's under 10%.
    I've sat here for ages trying to work it out, i presume it's something daft I'm overlooking so I need your help!

  2. #2
    Senior Member MaddAussie's Avatar
    Join Date
    Dec 2006
    Location
    Deepest Darkest Dorset
    Posts
    1,708
    Thanks
    628
    Thanked
    297 times in 179 posts
    • MaddAussie's system
      • Motherboard:
      • Asus ROG Strix Z370G
      • CPU:
      • i7 8700k (5.1Ghz)
      • Memory:
      • 16Gb
      • Storage:
      • 500G 960 EVO NMVE
      • Graphics card(s):
      • GTX 1070
      • PSU:
      • Corsair RM650i
      • Case:
      • Corsair Carbide A1r 240
      • Operating System:
      • Win 10
      • Monitor(s):
      • 24" Dell HD + Samsung HD

    Re: Microsoft excel....help!

    Conditional formatting?

  3. Received thanks from:

    Krakkenbus (04-05-2010)

  4. #3
    Senior Member
    Join Date
    Feb 2008
    Posts
    326
    Thanks
    38
    Thanked
    15 times in 13 posts
    • Krakkenbus's system
      • Motherboard:
      • MSI P55-GD65
      • CPU:
      • i5 750 @ 3.4GHz
      • Memory:
      • 8GB G.skill Ripjaw
      • Storage:
      • 6TB+
      • Graphics card(s):
      • 2GB 6950
      • PSU:
      • Enermax Liberty 620W
      • Case:
      • Coolermaster Cosmos
      • Operating System:
      • 7 Ultimate 64bit
      • Monitor(s):
      • 2xSamsung 22"
      • Internet:
      • FTTC @ 50 Mb/s

    Re: Microsoft excel....help!

    That's it! You sir are a legend. Ta

  5. #4
    Mostly Me Lucio's Avatar
    Join Date
    Mar 2007
    Location
    Tring
    Posts
    5,163
    Thanks
    443
    Thanked
    448 times in 351 posts
    • Lucio's system
      • Motherboard:
      • Gigabyte GA-970A-UD3P
      • CPU:
      • AMD FX-6350 with Cooler Master Seldon 240
      • Memory:
      • 2x4GB Corsair DDR3 Vengeance
      • Storage:
      • 128GB Toshiba, 2.5" SSD, 1TB WD Blue WD10EZEX, 500GB Seagate Baracuda 7200.11
      • Graphics card(s):
      • Sapphire R9 270X 4GB
      • PSU:
      • 600W Silverstone Strider SST-ST60F
      • Case:
      • Cooler Master HAF XB
      • Operating System:
      • Windows 8.1 64Bit
      • Monitor(s):
      • Samsung 2032BW, 1680 x 1050
      • Internet:
      • 16Mb Plusnet

    Re: Microsoft excel....help!

    A legend indeed for saving you 5 minutes with the help file

    (\___/) (\___/) (\___/) (\___/) (\___/) (\___/) (\___/)
    (='.'=) (='.'=) (='.'=) (='.'=) (='.'=) (='.'=) (='.'=)
    (")_(") (")_(") (")_(") (")_(") (")_(") (")_(") (")_(")


    This is bunny and friends. He is fed up waiting for everyone to help him out, and decided to help himself instead!

  6. #5
    Registered User
    Join Date
    Jul 2003
    Location
    Cornwall/Weston-Super-Mare
    Posts
    5,337
    Thanks
    438
    Thanked
    309 times in 262 posts
    • Behemoth's system
      • Motherboard:
      • Gigabyte mATX
      • CPU:
      • Phenom 2 X2 555 BE
      • Memory:
      • 8 Gig DDR3 Corsair XMS 3 1600 MHz
      • Storage:
      • 4 TB's Storage
      • Graphics card(s):
      • Gigabyte GTX 460 OC2
      • PSU:
      • OCZ StealthStream 2 600 Watt
      • Case:
      • Silverstone TJ08-E
      • Operating System:
      • Windows 7 64 Bit
      • Monitor(s):
      • HP x23LED
      • Internet:
      • BT Broadband

    Re: Microsoft excel....help!

    Whats a help file ?

  7. #6
    Formerly known as Andehh Andeh13's Avatar
    Join Date
    Oct 2005
    Location
    Northampton
    Posts
    3,353
    Thanks
    855
    Thanked
    257 times in 152 posts
    • Andeh13's system
      • Motherboard:
      • Gigabyte GA-P35
      • CPU:
      • Intel Q6600
      • Memory:
      • 4gb Corsair XMS2 800mhz
      • Storage:
      • 1 x 250gb Western Digital AAKS, 2 x 500gb Western Digital AAKS, 1TB WD Caviar Green
      • Graphics card(s):
      • BFG Geforce 8800GTS 512mb
      • PSU:
      • Corsair HX520
      • Case:
      • Antec 900
      • Operating System:
      • Windows 7 64bit
      • Monitor(s):
      • Samsung 24" & Sony 17"
      • Internet:
      • Virgin 10mb... hate them!

    Re: Microsoft excel....help!

    Quote Originally Posted by Behemoth View Post
    Whats a help file ?
    a myth

  8. #7
    Not a good person scaryjim's Avatar
    Join Date
    Jan 2009
    Location
    Gateshead
    Posts
    15,196
    Thanks
    1,230
    Thanked
    2,291 times in 1,874 posts
    • scaryjim's system
      • Motherboard:
      • Dell Inspiron
      • CPU:
      • Core i5 8250U
      • Memory:
      • 2x 4GB DDR4 2666
      • Storage:
      • 128GB M.2 SSD + 1TB HDD
      • Graphics card(s):
      • Radeon R5 230
      • PSU:
      • Battery/Dell brick
      • Case:
      • Dell Inspiron 5570
      • Operating System:
      • Windows 10
      • Monitor(s):
      • 15" 1080p laptop panel

    Re: Microsoft excel....help!

    *ahemahem*

    RTFM!!!

    thankyouverymuch.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [Review] Microsoft Natural Ergonomic Keyboard 4000
    By Zoom7000 in forum Reader Reviews
    Replies: 3
    Last Post: 15-10-2009, 09:25 AM
  2. Microsoft Excel Formulae
    By PeterStoba in forum Software
    Replies: 4
    Last Post: 23-10-2008, 09:05 PM
  3. Replies: 12
    Last Post: 01-06-2008, 10:30 PM
  4. Microsoft 2007 Ultimate £38.95 - Students!!
    By Mnet_Gaming in forum Retail Therapy and Bargains
    Replies: 18
    Last Post: 19-09-2007, 10:29 PM
  5. New RPC hotfix from Microsoft
    By Paul Adams in forum Software
    Replies: 12
    Last Post: 14-09-2003, 08:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •