Google Spreadsheet magic

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Sly
    Let's do some business!
    • Sep 2004
    • 31376
    #1

    Google Spreadsheet magic

    Let's say that I have a spreadsheet full of formulas. One of the formulas spits out a percentage. If the percentage is above 90%, I would like the cell to automatically fill green. If the percentage is 80%, I would like the cell to automatically fill yellow. If the percentage is 70%, I would like the cell to automatically fill pink.

    Is this possible? What do I do?
    Vacares - Web Hosting, Domains, O365, Security & More - Paxum and BTC Accepted

    Windows VPS now available
    Great for TSS, Nifty Stats, remote work, virtual assistants, etc.
    Click here for more details.
    Tags: None
    • CaptainWolfy
      Playa
      • Dec 2005
      • 8439
      #2
      format > conditional formatting.. i think you can find out your way from there..

        Comment

        • Sly
          Let's do some business!
          • Sep 2004
          • 31376
          #3
          Originally posted by CaptainWolfy
          format > conditional formatting.. i think you can find out your way from there..
          That worked great. Thank you.
          Vacares - Web Hosting, Domains, O365, Security & More - Paxum and BTC Accepted

          Windows VPS now available
          Great for TSS, Nifty Stats, remote work, virtual assistants, etc.
          Click here for more details.

            Comment

            • CaptainWolfy
              Playa
              • Dec 2005
              • 8439
              #4
              Originally posted by Sly
              That worked great. Thank you.
              np, any time, glad i could help ;)

                Comment

                Previous template Next
                Working...