How can I Conditional format cells with a formula in them instead of a value.
I am using the Mid function to extract a text string to a column, then I
want to use Conditional formatting to highlight the cells that matches any
cell in another range of cells. Any ideas?

In the cell you are trying to CF, use the Formula Is option for entering
your CF. I started in cell A1 where I have my MID statement to pull
from text in another cell. I1:I5 is the range of values I am looking
for to base my CF on. If the value in A1 is found in I1:K6 then the
formatting occurs.

Condition 1

Formula is:

=A1=INDEX($I$1:$I$5,MATCH(A1,$I$1:$I$5,0))

Select the format you want. Use the format painter to copy this down
your column. Make sure the A1 is not an absolute reference before
doing that or the format will always look at A1 and not the rest of
your column.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=498832