Conditional Formatting based on cell / range id / location

Thanks!

What about a range?

Say K17:N18

Originally Posted by drgkt

Thanks!

What about a range?

Say K17:N18

Hi,

I think you can use this CF formula:

=AND(OR(ROW()=17,ROW()=18),OR(COLUMN()=11,COLUMN()=12))

Column number:
11=K
12=N

Adjust accordingly (columns / rows)

Blessing

Khalidngo, is close but 11 and 12 are columns K & L.
For K-N this will work =AND(OR(ROW()=17,ROW()=18),AND(COLUMN()>10,COLUMN()<15))

Originally Posted by Beamernsw

Khalidngo, is close but 11 and 12 are columns K & L.
For K-N this will work =AND(OR(ROW()=17,ROW()=18),AND(COLUMN()>10,COLUMN()<15))

Ah, sorry my mistake.

Thanks for correction.

Suppose on the above conditional formatting we give a cell color yellow.

If a cell within the range is moved to location outside the range, then the cell within the range becomes white (because it has lost the CF formula) and the target cell outside the range becomes yellow even though it carries the CF formula.

Any way to preserve the range cell color even in the above scenario?

No ideas anyone?

Solved here: http://www.excelforum.com/showthread.php?t=1171692