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.
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?