HAN.xlsx [Read-Only] - Excel at Microsoft Excel!
Home
Introduction
Excel
101
So, you're new to spreadsheet huh.. Check this out!
Excel
Formula
How to write an excel formula!
New Posts
Love
Meter
Who is Your Crush's Big Time Crush?
Unprotect
Sheet
Remove password from protected worksheets and workbooks!
Dictionary
Attack
Open password-protected excel file using a dictionary attack!
Projects
Gag
Love
Meter
Who is Your Crush's Big Time Crush?
Other
Gag
Coming soon!
Social Network
Excel
Facebook
Coming soon!
Excel
Twitter
Coming soon!
Games
Formulas
Financial Modeling
Developer
Passwords
Password Recovery
Unprotect
Sheet
Remove password from protected worksheets and workbooks!
Dictionary
Attack
Open password-protected excel file using a dictionary attack!
Brute-force
Attack
Learn how to open password protected Excel File! Coming soon!
About
HANxlsx
About
Me
A little intro..
Privacy
Policy
Privacy Policy!
Disclaimer
Disclaimer!

[back to top!]

Coming up next!

Chatting and updating status using excel spreadsheet like a boss!

Our next excel project is to create a facebook-like excel spreadsheet that works like facebook. You don't say.. :D

Stay tuned, people! More cool stuff is coming!

Tuesday, November 6, 2012

Conditional Formatting


For those who don't know about this function yet, conditional formatting allows us to format certain cells if it meets certain criteria. It can be useful to highlight certain cells in a list with a defining characteristic e.g. greater than certain amount, lower than certain amount, and etc.

See the following embedded final version of conditional formatting spreadsheet or click Download! to grab the file directly from hanxlsx.com.







So this is the data that we need to sort out and apply the cond-formatting-magic on it!






























Let's see how to do it! We are going to highlight the participants from "Indonesia"

-  Now open your downloaded file and go to sheet Data.

-  Highlight cells C3 to F17;

-  Then go to ribbon "Home" on the worksheet menu bar and select "Conditional Formatting";

-  In the “Conditional Formatting” pop up, select “Highlight Cells Rules” and ”Equal to

-  Type “Indonesia in the first box (You can also direct it to any Cell) in the “Equal to” pop up;

-  In the second box in the “Equal to” pop up, click on the drop down list and select “custom format”.

-  Click on the yellow color box in the “Fill” tab and then on the “OK” button;

-  On “Equal to” pop up, click the “OK” button again.


Here is a screen shot for cells to be highlighted yellow where Indonesia is in the cell:































To clear out the conditional formatting, see the following image:






















Try yourself to set up a new conditional formatting to highlight cells green where the points are between 60 and 70. Go to sheet "Conditional Formatting". That's it! Send me an email if you need more explanation on this tutorial.