conditional formatting

  • Thread starter Thread starter scouser
  • Start date Start date
S

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
 
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.
 
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
 
Back
Top