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