Discussion Locked

Excel 2007 Conditional Formatting: Range of values

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am familiar with conditional formatting in Excel 2007 and have successfully highlighted cells which contain specific 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?

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.