Index(match) & conditional format vba instead

[Musab]

Hi Guys,

This is a difficult query, unless I'm not seeing something here sorry I typed this one up in a messy way. Hopefully you guys can follow this.

I have a MAIN SHEET with a column containing ID, and this ID column is linked to 2 different sheets via index matches, ID UPDATE & ID NEW. The details in said ID is edited via the user in the 2 different sheets AND NOT in the MAIN SHEET.

The way I want to show visible updates to ID details is done via a conditional format simply making the text red and bold. Now in order to achieve this I have the following simple excel functions called:



I have 5 columns (the details in ID -> ID DESCRIPTION, ID TYPE, etcetc) running =IFNA(IFNA(IF(INDEX(RANGE(A:Z),MATCH(X8,TABLE1[DATA1],0),3)=0,(INDEX(RANGE(A:Z),MATCH(X8,TABLE1[DATA1],0),2)),INDEX(RANGE(A:Z),MATCH(X8,TABLE1[DATA1],0),3)),(INDEX(TABLE3,MATCH(DATA2,TABLE3[DATA1],0),2))),"") - this is an example. Sorry if that's hard to follow..

With 5 conditional formats on all columns (now you see why it lags - note this is what makes the changes to the ID filed red.
NEW RULE > FORMULA >
=INDEX(RANGE,MATCH(VALUE,COLUMN,0),COLUMNNUMBER)<> VALUE2
APPLIED TO RANGE: whole column

Now is there a way to do this without lagging the hell out of my spreadsheets