Code help please

rjc4

Well-known Member
Joined
Nov 6, 2004
Messages
502
Hi All,

I have a dropdown list in cell A7 which contains numbers.

In columnF I have Conditional formatting of:-
=Rank(A8,$A$8:$A$31,1)<=6

I want to replace the 6 with a reference to the contents of cell A7.

I tried (R7C1).....no good also in commas but neither works.
Could anyone help with the correct syntax please.

Thanks
RC
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,118,334
Messages
5,571,589
Members
412,407
Latest member
ElmerCC
Top