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
