Posted: 11/7/2008 1:08:39 PM EDT
|
The bean counters have made up an Excel spread sheet for some data collection I'm doing on the road. They're all out of the office and I have a problem.
They have it set up so if I enter "xxx (1)" in a cell, it will highlight orange, and "xxxx" will highlight green. My problem is I've found I need to enter "xxx abc" or "xxx xyz" to denote something, and this text will not highlight the cell for me. Anyone know how I can change this? Is it a macro or something? I'm not Office savvy in the least. |
|
It sounds like they have conditional formatting on the cell. Click on the cell and go to Format-Conditional Formatting. A box should pop up showing if this is true. You should also have an option to add another condition. Click the "Add" button and set the condition "equal" to "*abc" or "*xyz" and select the appropriate color under the format button. The asterisk is just a wildcard so that whatever is entered before the abc or xyz doesn't matter. Let me know if this works for you or if you have any questions.
Matt |
|
Quoted:
You are exactly right. The only problem is I need more than 3 conditional probabilities and that isn't allowed. Looks like I'll have to start a whole 'nother column. If you only need 4 conditions, and every cell will be populated, then you can format the column to some color first, then with the 3 conditions, you will have 4 colors. GH |
|
Not every cell is populated, this spreadsheet is used in the field as a hardcopy and then updated in the evening, a new hardcopy is generated every morning to make it easier on me.
It's ok, I appreciate the help. Another column is no problem. And it's even going to be in pretty colors now too. They should have just given me crayons. |