microsoft-excel-courses - auto colour change

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Auto colour change

microsoft-excel-courses - Auto colour change

resolvedResolved · Low Priority · Version Standard

Stacey has attended:
Excel Intermediate course

Auto colour change

How do you get the cells to automatically change colour if figure entered is above or below target set.

RE: auto colour change

Hi Stacey, Thank you for your post, I hope you enjoyed the Excel Intermediate Course, In answer to your question: To do this I would choose Excel's Conditional Formatting Option.
Select the cell or range of cells that you wish to control: From the Menu Bar choose Format, Conditional Formatting. This will open a dialog box which will allow you to choose from a number of numerical operators ie above, below, equal to etc. etc., and to enter the value you have chosen as your target. By clicking on the Format button you will open the Format Cells dialog box which will allow you to apply Font Colouring, Cell Colouring and Cell Borders, or any combination of the three. You can then click on the Add button to add any additional condiditions that you wish to apply, in your case you would have two options, one to format the cells for above target, the second to format the cells for below target. I hope that helps, best regards Pete

 

Training courses

 

Training information:

See also:

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.


 

Excel tip:

Create a hyperlink navigation sheet

In large files, it is often useful to have a front sheet with hyperlinks to the key databases and summary calculations in your spreadsheet. Hyperlinks can save you and (more importantly) those less familiar with your spreadsheet a great deal of pointless scrolling between and within sheets.



Hyperlinks appear as underlined text and can jump to any cell or range name in your file. You can also use hyperlinks to jump to other files.



To create a hyperlink to a location in the active workbook: (1) Select the cell that contains the text you want to use as the hyperlink and choose Insert|Hyperlink.(2)Click Place in this document.(3)Choose the sheet you want to link to or the range name from the list of "Defined Names".(4)If necessary, type the cell reference in the Type in the cell reference box. (5) Click OK.

View all Excel hints and tips


Server loaded in 0.09 secs.