Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional Formattig
Sharon has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced - Formulas & Functions course
is there anyway to highlight a whole line of cells when only one cell contains a certain value. eg cell B2 = SAT so I want all the cells in the table in that row to be highlighted a certain colour, not just that cell.
Any ideas?
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.
If you know how to use the auto-fill option on Excel then why not create your own customs lists?
The auto fill feature saves you time by allowing you to enter one of the list entries into a cell and then use your mouse to automatically drag the rest of the list into the cells below, above or to either side of the initial cell. When using your mouse to perform this task you will see a thin black cross appear at the bottom right hand side of the cell. Click, hold and drag to make the list appear.
Default lists include weekdays and months. To create your own list in Excel 2010 do the following;
>File
>Options
>Advanced
>Scroll right to the bottom of the page and you will see a buttom "edit custom lists", click this button
>enter your list in the list entries
>click add
Now try it out. Good luck.
>
TrustScore
4.9
/ 5
2394 reviews
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
