Conditional formatting

A

aware

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

SteveG

In the cell you are trying to CF, use the Formula Is option for enterin
your CF. I started in cell A1 where I have my MID statement to pul
from text in another cell. I1:I5 is the range of values I am lookin
for to base my CF on. If the value in A1 is found in I1:K6 then th
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 dow
your column. Make sure the A1 is not an absolute reference befor
doing that or the format will always look at A1 and not the rest o
your column.

HTH

Stev
 
Top