excel training in uk - Color Coding

The UK's most regular instructor-led training courses.
Training information: excel training in uk · Excel/courses/london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Color Coding

Doron has attended:
Excel Intermediate course

by - delegate Doron [1 post] (2007 Aug 16 Thu, 13:48) Reply

I have seen excell sheets that automatically highlight a cell in red if the number is negative, and leave it in black if it is positive. How can I program this?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Color Coding

by - trainer Tracy platinum contributer [586 posts] (2007 Aug 16 Thu, 15:00) Reply

Hi Doron,

Thanks for the question.

These can be found if you go to Format-> Cells and the first tab number. If you look there you will see options where you can choose different colours for negative or positive values.

Good luck

Tracy

· Interesting Lifestyle Applications for Microsoft Excel
· How Small Businesses Profit from Outside Excel Training
· What's Better Than the Help Function in Excel? Microsoft Training
· How to check for and reduce errors in Microsoft Excel
· Customized Financial Excel Courses in London

Excel tip:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)

View all Excel hints and tips