General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Related Discussions
-
0
-
6
-
0
-
2
-
0
Excel 2007 Conditional Formatting: Range of values
The problem is I can't find a way to reference a range of values and therefore have to create several different conditions, as follows:
"Specific Text Containing "8/4 "
"Specific Text Containing "9/4 "
- ten entries to cover two weeks.
The cells contain journal type entries with dates as shown in the example above.
Is there a way to specify a range of values? I've tried naming a range but this didn't work.
I've also tried using a formula similar to the following but couldn't get it to reference a range:
=NOT(ISERR(SEARCH("10/4 ",C5)))
=NOT(ISERR(SEARCH(insert range here,C5)))
Any ideas?
This conversation is currently closed to new comments.