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
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
here's what I've done. Used =CELL("address",OFFSET(Sheet1!$A$1,Sheet1!$Q$8,She et1!$Q$7,1,1))=ADDRESS(ROW(Sheet1!A1),COLUMN(Sheet 1!A1)) as conditional format formula starting from B2 to M13
Hi
Or
=AND(ROWS(B$2:B2)<=$Q$8,COLUMNS($B2:B2)<=$Q$7)
Excellent Guys
Thank you
A better solution Admin. Had to make a minor modification though
=AND(ROWS(B$2:B2)=$Q$8,COLUMNS($B2:B2)=$Q$7)