98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Make selection of cells with a condtion change cell colour
Make selection of cells with a condtion change cell colour
Resolved · Low Priority · Version 2003
Fri 29 Aug 2008, 11:39Delegate Natalie said...
Natalie has attended:
Excel Advanced course
Make selection of cells with a condtion change cell colour
Can you select a column and can certain cells in that column be changed to a particular colour if for example the cell is great then 10 or less then 3?
Tue 9 Sep 2008, 16:05Trainer David said...
RE: Make selection of cells with a condtion change cell colour
Yes it is called conditional formating. we cover it in Intermediate level.
Choose format/conditional format
choose cell value greater than 10 then click on Format button and select the colour you want it to change to.
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Calculate age or serviceThe DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip: |
