Use this as the conditional format formula =MATCH(ADDRESS(ROW,COLUMN,4,1),AddressList!$A:$A,0) Where the sheet and column containing addresses is sheet AddressList, column A How it works. ROW returns the row of the cell containing the formula (either in the cell itself, or in conditional formatting on the cell. COLUMN ditto for column. ADDRESS( r, c, 4, 1) returns the address or row r, column c. 4 means relative (ie no $'s. 1 means A1 style. So ADDRESS(ROW,COLUMN,4,1) will be the address of the conditionally formatted cell in A1 notation.
![]()
This course features tons of tips to make Excel for Mac 2011 users more proficient and productive with the popular spreadsheet program. Learn the top shortcuts, find out how to most efficiently.
![]()
MATCH(val, AddressList!$A:$A, 0) searches for val in range AddressList!$A:$A, 0 means exact match. Returns row number if val is found, #N/A if not. Conditional format treats a possitive number as True and #N/A as false.
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |