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 » Conditional formatting
Conditional formatting
Resolved · Low Priority · Version 2007
Wed 29 Jun 2011, 16:49Delegate Jenny said...
Jenny has attended:
Excel Intermediate course
Word Advanced course
Conditional formatting
Can you format a whole row by colour even though the criteria is only in one column?
Thu 30 Jun 2011, 09:30Trainer Stephen said...
RE: Conditional formatting
Hi Jenny
Thanks for your question
Please could you expand a little on your question. Are you looking to format a whole range based on the value in a single cell.
So for example if the first cell in the row contains a particular value, then the whole row is formatted?
Thanks
Stephen
Mon 11 Jul 2011, 09:43Trainer Stephen said...
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Sun 17 Jul 2011: Automatically marked as resolved.
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:Enter formulae into multiple cellsIf a formula is to be used in a series of cells, select the cells first. Now type in your formula and hold the Ctrl key while you press Enter. This enters the formula in each selected cell. |
