copy cell format along with content in an xlookup

[schroederdj]

Is there a way, without vba code, to bring back the cell format along with contents in an xlookup? If no, can you share the vba coding to bring back the cell format along with contents in an xlookup?

 

[GlennUK]

Explain why you want this to happen, how the VBA code is supposed to be called (because cell formula functions will NOT do what you want), and any other relevant information.

 

[schroederdj]

I have an xlookup that is running through VBA code. the xlookup works fin and brings back the desired data. However the data source is also formatted (color coded) to mean different things. I would like to bring this formatting along with the the data

 

[Joe4]

Is the color formatting controlled by Conditional Formatting?
If so, you should be able to apply the same Conditional Formatting rules to your destination.

If it is not due to Conditional Formatting, and you do not want to use VBA, then you are out of luck. As Glenn alluded to, Excel formulas can only look at cells values, not any formatting applied on those cells. So there is no way to do it without VBA.

 

[schroederdj]

Is the color formatting controlled by Conditional Formatting?
If so, you should be able to apply the same Conditional Formatting rules to your destination.

If it is not due to Conditional Formatting, and you do not want to use VBA, then you are out of luck. As Glenn alluded to, Excel formulas can only look at cells values, not any formatting applied on those cells. So there is no way to do it without VBA.

unfortunately it is not conditional formatting. it is simply red for "problem", yellow "maybe a problem", green "ok" The database has new activity added everyday and I wanted to bring back the same coloring on previously looked at items rather than just the wording for a visual to the user. I think they will have to be satisfied with just the wording. the wording i mention above is ust a sample so it wouldn't always be that wording that could add conditional formatting to.

 

[Joe4]

One potential change you could make is to create a Data Validation List on a column that only has the following three options:
- Problem
- Maybe a problem
- OK

So instead of them selecting a color, they make a selection from the drop-down box.
Then apply three Conditional Formatting rules based off of that field value to apply your three colors automatically.

If you do that, then you can apply the same Conditional Formatting rules on your destination sheet.