I want to higlight the vlook up error"Not Indicated" cell to red,
any ideas on how to do this ?
The code below:
![]()
Range("P3").FormulaR1C1 = "=IF(C[-3]="""","""",IFERROR(VLOOKUP(C[-3],SAPUSERMASTER.xlsx!R1:R1048576,2,0),""NOT INDICATED""))" 'User Dept Range("Q3").FormulaR1C1 = "=IF(C[-4]="""","""",IFERROR(VLOOKUP(C[-4],SAPUSERMASTER.xlsx!R1:R1048576,3,0),""NOT INDICATED""))"
Bookmarks