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
9359 posts

Uber Geek
+1 received by user: 1562

Mod Emeritus
Trusted
Lifetime subscriber

Topic # 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 : i3-3240 @ 3.40GHz  16GB RAM  Win 10 Pro    Workstation : i5-3570K @ 3.40GHz  16GB RAM  RX580 4GB Win 10 Pro    Console : Xbox One

 

https://www.xpd.co.nz - Games, geeks, and more.    

Create new topic
372 posts

Ultimate Geek
+1 received by user: 42


  Reply # 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
9359 posts

Uber Geek
+1 received by user: 1562

Mod Emeritus
Trusted
Lifetime subscriber

  Reply # 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 : i3-3240 @ 3.40GHz  16GB RAM  Win 10 Pro    Workstation : i5-3570K @ 3.40GHz  16GB RAM  RX580 4GB Win 10 Pro    Console : Xbox One

 

https://www.xpd.co.nz - Games, geeks, and more.    

 
 
 
 


324 posts

Ultimate Geek
+1 received by user: 8

Trusted

  Reply # 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
9359 posts

Uber Geek
+1 received by user: 1562

Mod Emeritus
Trusted
Lifetime subscriber

  Reply # 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 : i3-3240 @ 3.40GHz  16GB RAM  Win 10 Pro    Workstation : i5-3570K @ 3.40GHz  16GB RAM  RX580 4GB Win 10 Pro    Console : Xbox One

 

https://www.xpd.co.nz - Games, geeks, and more.    

Create new topic


Donate via Givealittle


Twitter »

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 »

A call from the companies providing internet access for the great majority of New Zealanders, to the companies with the greatest influence over social media content
Posted 19-Mar-2019 15:21

Two e-scooter companies selected for Wellington trial
Posted 15-Mar-2019 17:33

GeForce GTX 1660 available now
Posted 15-Mar-2019 08:47

Artificial Intelligence to double the rate of innovation in New Zealand by 2021
Posted 13-Mar-2019 14:47

LG demonstrates smart home concepts at LG InnoFest
Posted 13-Mar-2019 14:45

New Zealanders buying more expensive smartphones
Posted 11-Mar-2019 09:52

2degrees Offers Amazon Prime Video to Broadband Customers
Posted 8-Mar-2019 14:10

D-Link ANZ launches D-Fend AC2600 Wi-Fi Router Protected by McAfee
Posted 7-Mar-2019 11:09

Slingshot commissions celebrities to design new modems
Posted 5-Mar-2019 08:58

Symantec Annual Threat Report reveals more ambitious, destructive and stealthy attacks
Posted 28-Feb-2019 10:14

FUJIFILM launches high performing X-T30
Posted 28-Feb-2019 09:40

Netflix is killing content piracy says research
Posted 28-Feb-2019 09:33

Trend Micro finds shifting threats require kiwis to rethink security priorities
Posted 28-Feb-2019 09:27

Mainfreight uses Spark IoT Asset Tracking service
Posted 28-Feb-2019 09:25

Spark IoT network now covers 98% of New Zealand population
Posted 19-Feb-2019 09:28


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.