conditional formatting
The UK's Number 1 for Microsoft Office Training
Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional Formatting

Recommend training98.1 %
recommend us
More live stats...

The UK's most regular
instructor-led training courses.

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

See also:
Hints and tips
Forum topics

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Conditional Formatting

resolvedResolved · Medium Priority · Version 2003

replyReply Wed 24 Nov 2010, 16:23Delegate Richard said...

Richard has attended:
Excel Intermediate course
Excel Advanced course

Conditional Formatting

How to set the above when
50% (100/200) is in the cell and you only want the colour to change in another cell by reading the %, i.e. the 50% being the main figure against the target of 100%.

For upcoming training course dates see: Pricing & availability

replyReply Mon 29 Nov 2010, 10:25Trainer Simon said...

RE: Conditional Formatting

Hi Richard,

Thank you for your question.

Click into the relevant cell and go to Format and then Conditional Formatting.

Choose Formula is and enter = followed by the cell reference containing the % amount. Follow that by an equals sign and finally enter the value you want the cell to be tested against.

e.g. Formula is =c2=50%

I hope this answers your question.

Regards

Simon

Sun 5 Dec 2010: Automatically marked as resolved.

 

Excel articles

· How To Create An Argument With Excel
· Charting Your Success With Excel 2007
· How To Use Freeze Panes In Excel 2007
· Inviting Investment Into Your Business Can Be Easier With Excel
· Excel Macros for the Non-Programmer

Please browse our web site to find out more about
excel classes and other Microsoft training courses.

Excel tip:

Convert a column into row quickly in Excel 2010

Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa.

First, select the column you want to convert into a row or a row into a column. Then right click and select Copy. Go to the sheet where you want to past this row as a column and select “Paste Special”. Remember to check the check-box “Transpose” and select “OK”.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. infomst
All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy


Please tell us/web development about this error (copy and paste into an e-mail):
MySQL error: Duplicate entry '5' for key 'PRIMARY'
Line: 76
Actual SQL Query: insert into best_activevisitors (activevisitors_ID, activevisitors_IP, activevisitors_Time, activevisitors_Url) values (5, "38.107.179.244", now(), "/cms/forum.php")
Reported by: function sqlQueryBest()
When viewing (PHP_SELF): /cms/forum.php
Query string from URL: fpost_id=27929