Highlight A Cell Using Conditional Format Using Row And Column Index

[rich_cirillo]

Hi

How do I apply condition formatting to the cell range B2:M13 by the answer in Q10....how do I have the answer in cell Q10 (30) be highlighted in the table....can it be either Red or a double border

Cheers

Rich

[Excel Fox]

here's what I've done. Used =CELL("address",OFFSET(Sheet1!$A$1,Sheet1!$Q$8,Sheet1!$Q$7,1,1))= ADDRESS(ROW(Sheet1!A1),COLUMN(Sheet1!A1)) as conditional format formula starting from B2 to M13

[Admin]

Hi

Or


=AND(ROWS(B$2:B2)<=$Q$8,COLUMNS($B2:B2)<=$Q$7)

[rich_cirillo]

Excellent Guys
Thank you

[Excel Fox]

A better solution Admin. Had to make a minor modification though

=AND(ROWS(B$2:B2)=$Q$8,COLUMNS($B2:B2)=$Q$7)