All masters,
Need conditional formatting or any formulas method for Highlighting cell range column "C", with reference to "J" column range values.
or example: at "J2" value is "902000799" so at "C" column, this "902000799" value we can find at "c" column is at "C492" cell. so i want the fill with red color at "C492" cell
and at "J3" cell value is 903000436, we can found at "C63" cell. so i want the fill with red color at "C63" cell.
and at "J4" cell value is 903000438, we can found at "C104" cell. so i want the fill with red color at "C104" cell.
same like reaming cells at "C" column filled by red color with reference to match "J" column by equal values comparison.
Bookmarks