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
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Hi
Or
=AND(ROWS(B$2:B2)<=$Q$8,COLUMNS($B2:B2)<=$Q$7)
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
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)
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Posting Permissions
Reply With Quote
Bookmarks