Locating and shading cells with specific information

L

lydiaevans7

I am trying to shade cells that contain a specific value--whether it's
by itself or located in a series within the cell. When I try
conditional formatting, I am limited to equal to, less than, or
greater than. Is there an option to run conditional formatting using
an inclusive feature? Any help is greatly appreciated!
 
J

jpdphd

I am trying to shade cells that contain a specific value--whether it's
by itself or located in a series within the cell. When I try
conditional formatting, I am limited to equal to, less than, or
greater than. Is there an option to run conditional formatting using
an inclusive feature? Any help is greatly appreciated!
Click to expand...

What do you mean by "located in a series within the cell"? If you mean
that the cell A1 might contain the text:
="1,2,3,4,5"
then you can use the < Format is > option of conditional formatting
and enter
=FIND(A1,3,1)
Because this is TRUE in this instance, the conditional formatting is
applied.
Hope that helps!
jpdphd
 
Top