Expression for Conditional Formatting

B

Biff

Hi Alcide!

Will the cells contain only that one word - week? If so,
just enter it like this:

cell value is: equal to: week

No need for * unless the cell can contain text like this:

This week was great!

In which case you'd have to use a formula like:

=COUNTIF(A1,"*week*")

Biff
-----Original Message-----
Hello All,

I am trying to do a Conditional Format on any cell in a
column containing the word "week". Tried doing
LIKE "*week*" on the Expression Is line, but that returned
an error.
(Hoping to do a bunch of experimenting once I get past
this hurdle. Looking forward to my VB .Net class in the
fall.)
 
Top