11-10-2008, 07:55 PM
|
|
Registered User
|
|
Join Date: 10 Nov 2008
Location: Manchester UK
Posts: 2
|
|
|
Need Help!
I'm a daily Excel user and am familiar with the basics, but I am having a problem with a couple of things in my spreadsheets and was hoping some kind soul could advise me.
Let me apologise in advance if I have missed the answers to the questions below somewhere else.
Problem A
Conditional Formatting - I have a need to format more than three rules in a column, but it seems I can only have a maximum of three rules per column.
Is there a way of increasing the conditional formatting options for columns/rows so that extra data can be sorted/highlighted?
Problem B
One column of cells has multiple sets of data which I need to include automatically as extra data is added. Each cell itself may have up to seven individual pieces of data separated by a comma.
My problem is getting Excel to recognise a string of letters within a cell using =countif(A:A,"data1"), for example. As there is more than one string of information in the cell, it is failing to account for these instances, unless the string I am searching for is the only data in that cell.
I would like Excel to both recognise and count the instances where each string in a cell occurs. I can do this manually using 'Find All', but then the process has to be carried out every time the data in the spreadhseet changes.
I hope this makes sense to you. Any help would be greatly appreciated, and you can marry my first born daughter, assuming I ever have one. 
Last edited by pjoaquin; 11-10-2008 at 08:51 PM..
Reason: Closed, User created new thread with proper title
|
New topics in Excel 2007 Help
Linear Mode
