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

Uber Geek
+1 received by user: 1443

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-xxxx @ x.xxGHz  16GB RAM  Win 10 pro    Console : Xbox One

 

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

Create new topic
369 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
9146 posts

Uber Geek
+1 received by user: 1443

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-xxxx @ x.xxGHz  16GB RAM  Win 10 pro    Console : Xbox One

 

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

 
 
 
 


320 posts

Ultimate Geek
+1 received by user: 7

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

Uber Geek
+1 received by user: 1443

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-xxxx @ x.xxGHz  16GB RAM  Win 10 pro    Console : Xbox One

 

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

Create new topic



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:



Geekzone Live »

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


Geekzone Live »

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.