Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


Forums › Desktop computing › Excel... auto colour a cell

xpd



Chief Trash Bandit
10038 posts

Uber Geek

Mod Emeritus
Trusted
Lifetime subscriber

# 68506 23-Sep-2010 12:03
Send private message

Working on a spreadsheet to monitor/record out internet usage (entered manually) from 15+ branches - working fine, but what Im wondering, is it possible to get Excel (03) to automatically color a cell if the entry is over a certain limit so at a glance I can see whos been going over their limit without manually highlighting them. (Some branches have different data caps else Id do the highlighting as I entered the numbers)

ie: Branch1 uses under their data allowance so the cell remains default (white), but Branch2 goes over their limit of x and the cell gets highlighted/filled with red.

Any assistance appreciated :)





XPD / Gavin / DemiseNZ

 

Server : i5-3470s @ 3.50GHz  16GB RAM  Win 10 Pro    Workstation : i5-3570K @ 3.40GHz  20GB RAM  RX580 4GB Win 10 Pro    Console : Xbox One

 

https://www.xpd.co.nz - Games, emulation, geekery, and my attempts at photography.     Now on BigPipe 100/100 and 2Talk

 

Emulation - The art of getting your $4000 PC to run an 80's system - and still fails.

 

Add me on Steam

Create new topic
374 posts

Ultimate Geek


  # 383567 23-Sep-2010 12:09
Send private message

Check out the Conditional Formating feature - it will do what you want.




Things are LookingUp....  A photo from my back yard :-)
http://www.astrophotogallery.org/u141-rodm.html 

xpd



Chief Trash Bandit
10038 posts

Uber Geek

Mod Emeritus
Trusted
Lifetime subscriber

  # 383568 23-Sep-2010 12:10
Send private message

#fail for me... its Office 07 not 03 btw ;)

Thanks for the tip, will look it up :)




XPD / Gavin / DemiseNZ

 

Server : i5-3470s @ 3.50GHz  16GB RAM  Win 10 Pro    Workstation : i5-3570K @ 3.40GHz  20GB RAM  RX580 4GB Win 10 Pro    Console : Xbox One

 

https://www.xpd.co.nz - Games, emulation, geekery, and my attempts at photography.     Now on BigPipe 100/100 and 2Talk

 

Emulation - The art of getting your $4000 PC to run an 80's system - and still fails.

 

Add me on Steam

 
 
 
 


333 posts

Ultimate Geek

Trusted
Lifetime subscriber

  # 383574 23-Sep-2010 12:14
Send private message

As above - conditional formatting is relatively easy to follow.  In Excel 2007 there is, by default, a button on the "Home" ribbon entitled "conditional formatting".

xpd



Chief Trash Bandit
10038 posts

Uber Geek

Mod Emeritus
Trusted
Lifetime subscriber

  # 383578 23-Sep-2010 12:17
Send private message

Thanks very much, exactly what I want :)

Shows how often I use Excel..... ;)

Cheers




XPD / Gavin / DemiseNZ

 

Server : i5-3470s @ 3.50GHz  16GB RAM  Win 10 Pro    Workstation : i5-3570K @ 3.40GHz  20GB RAM  RX580 4GB Win 10 Pro    Console : Xbox One

 

https://www.xpd.co.nz - Games, emulation, geekery, and my attempts at photography.     Now on BigPipe 100/100 and 2Talk

 

Emulation - The art of getting your $4000 PC to run an 80's system - and still fails.

 

Add me on Steam

Create new topic



Twitter and LinkedIn »



Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:





News »

Arlo unveils its first video doorbell
Posted 21-Oct-2019 08:27

New Zealand students shortlisted for James Dyson Award
Posted 21-Oct-2019 08:18

Norton LifeLock Launches Norton 360
Posted 21-Oct-2019 08:11

Microsoft New Zealand Partner Awards results
Posted 18-Oct-2019 10:18

Logitech introduces new Made for Google keyboard and mouse devices
Posted 16-Oct-2019 13:36

MATTR launches to accelerate decentralised identity
Posted 16-Oct-2019 10:28

Vodafone X-Squad powers up for customers
Posted 16-Oct-2019 08:15

D Link ANZ launches EXO Smart Mesh Wi Fi Routers with McAfee protection
Posted 15-Oct-2019 11:31

Major Japanese retailer partners with smart New Zealand technology IMAGR
Posted 14-Oct-2019 10:29

Ola pioneers one-time passcode feature to fight rideshare fraud
Posted 14-Oct-2019 10:24

Spark Sport new home of NZC matches from 2020
Posted 10-Oct-2019 09:59

Meet Nola, Noel Leeming's new digital employee
Posted 4-Oct-2019 08:07

Registrations for Sprout Accelerator open for 2020 season
Posted 4-Oct-2019 08:02

Teletrac Navman welcomes AI tech leader Jens Meggers as new President
Posted 4-Oct-2019 07:41

Vodafone makes voice of 4G (VoLTE) official
Posted 4-Oct-2019 07:36


Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron


Updates »

Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.