conditional formatting

[scouser]

I have used conditional formatting to highlight cells in my
spreadsheet that contains the word "copy"

i.e
select all cells, make A1 active
condition 1 =Find("copy",A1).

I need to add a second condition that highlights a cell that is two
rows and three columns away from each of the highlighted cell.

e.g A3 contains "copy" so C6 is highlighted
A15 contains "copy" so C18 is highlighted

Any ideas?

Thanks for any help

Ian

 

[J.E. McGimpsey]

One way:

With C6 selected (and, if desired, others you want to receive the
same formatting, but C6 active)

CF2: =FIND("copy",A3)


You can then copy that CF to C18 and XL will convert the cell
reference to A15.

 

[Bernie Deitrick]

Ian,

First select C4, then shift-ctrl-end, and use the same formula for
your conditional formatting. Your initial selection provides the
offset.

HTH,
Bernie
MS Excel MVP