Hayley has attended:
Excel Intermediate course
Formatting in excel
If you have formatted a spreadsheet and several cells are highlighted that fall in your criteria, but they are scattered, so you cannot list them, is there a way to see how many cells are highlighted?
RE: formatting in excel
Hello Hayley,
Thank you for your question regarding formatting in Excel.
In Excel 2007 and 2010 you can sort or filter by colour. However, in 2003 you cannot do this. I presume you have certain criteria that you apply to the formatted cells and I would suggest that you try to create a filter using the same criteria.
If you send me your file I will be able to do this for you and send the file back. My email is:
rl@stl-training.co.uk
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
