Formula to copy data as well as all formatting

[honkin]

I have a formula which helps me keep one sheet updated when data in another sheet is updated, but one disappointing thing is only the contents of the original cell come across, not the formatting. Many of the cells are colour-coded for different price ranges, or negative numbers coloured differently to positive numbers. I'd like that same format to accompany the data.

Is this at all possible?

Here is the code

=IFERROR(INDEX('[predictology-ai-predictions.xlsx]Predictology'!$F$2:$F$49997,MATCH(1,INDEX((A26068='[predictology-ai-predictions.xlsx]Predictology'!$A$2:$A$49997)*(B26068='[predictology-ai-predictions.xlsx]Predictology'!$B$2:$B$49997)*(C26068='[predictology-ai-predictions.xlsx]Predictology'!$C$2:$C$49997),0,1),0)),"No")

Basically if columns A, B & C match, the data in F, in this instance, comes into where I put this code, but only the numbers come across

Here is an example of the look of some cells

Is there a way to amend my formula so the contents of the cell come across, including all formatting?

Cheers

 

[Peter_SSs]

No, a formula cannot apply formatting like that.

If the original colours are applied by Conditional Formatting then perhaps it may be possible to apply similar Conditional Formatting in the formula worksheet but that would depend on exactly what that CF was.

Otherwise, your only option would be to take a completely different approach and do the job with vba.

 

[honkin]

No, a formula cannot apply formatting like that.

If the original colours are applied by Conditional Formatting then perhaps it may be possible to apply similar Conditional Formatting in the formula worksheet but that would depend on exactly what that CF was.

Otherwise, your only option would be to take a completely different approach and do the job with vba.

Thanks Peter. May see if I can find the CF that was used, if not, maybe vba is a solution

cheers