Conditional Formatting Rule

Hi Samantha


Thank you for your question.

Conditional Formatting is a technique to format cells based on one or more rules or conditions, i.e. different criteria.
Cells greater than 10000 - Green
Cells greater than 5000 - Amber
Cells greater than 1000 - Red

It can help you visually explore and analyse data collected in an Excel worksheet, detect critical issues, and identify trends, patterns and exceptions.

In Excel 2007, conditional formatting has been vastly improved and it is now possible to specify any number of rules for a cell or range of cells.

Please see link below for further explanation & example of how conditional formatting can be used.

http://office.microsoft.com/en-us/excel-help/demo-data-takes-shape-with-conditional-formatting-HA010165549.aspx


I hope this resolves your question. If it has, please mark this question as resolved.


If you require further assistance, please reply to this post.


Regards,


Nafeesa

Microsoft Office Specialist Trainer