98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Highlighting cells
Highlighting cells
Resolved · Low Priority · Version 2003
Nikki has attended:
Excel Advanced course
Highlighting cells
How do you highlight visable cells only? i.e. on a subtotal page ?
RE: Highlighting cells
Hi Nikki, Welcome to the forum, Thank you for your post, This is a great question and one which has had a lot of people stumped, but to sort your problem we have to use a little cheating;
Follow these steps;
1. View just the subtotals you wish to highlight (Click level 2 or similar)
2. Select just the cells you want to highlight
Here comes the cheat
3. Click Edit>Go To (Ctrl+G)
4. In the dialog box click the Special Button
5. In the Go To Special dialog box select Visible Cells Only
Click Ok - Now Format the cells as required; Click to View all of your Datasheet and you will see only the Selected cells have been formatted.
Do you like it? If so please click the Resolved link, best regards Pete Emmerson Microsoft Office Specialist Master Instructor
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:Generating Random NumbersTo generate a random number in Excel use the = RAND() function. |