|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
11-10-2008, 08:00 PM
|
|||
|
|||
|
Conditional Formatting/Counting Data Strings
Sorry re-posting because of useless thread title (read the rules now!)
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. 
|
|
#2
11-10-2008, 09:07 PM
|
||||
|
||||
|
For Problem A, just keep pushing New Rule. (You are using Excel 2007, I assume, since you're posting in the Excel 2007 forum. If not, three is all you get.)
The answer to Problem B is to not have a single cell containing multiple data items. That's not the way Excel is designed to work. It can be hacked, but then you'll have a hacked bad design. You can separate them using text to columns, or, if necessary, VBA.
__________________
Entia non sunt multiplicanda sine necessitate.
|
|
#3
11-10-2008, 09:29 PM
|
||||
|
||||
|
Problem A
A non-VBA way to get up to 6: http://www.ozgrid.com/Excel/font-formats.htm A VBA way to get as many as you want: http://www.ozgrid.com/VBA/excel-cond...ting-limit.htm
__________________
"Actually, I am a rocket scientist." - JB
|
 |
| Bookmarks |
New topics in Excel 2007 Help
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
