UDF

[srinidhi]

I am using index & match formula for getting the data based on 2 condition.

I want an UDF which will show the result (value) along the formatting (Cell Colour) from the source data in the result.


Example if the source data cell has the text as SRI & the cell colour is blue, in the result I want the text as SRI & the cell should be blue in colour.

 

[Luke M]

Can't do that, as UDF's can't change other parts of the worksheet (such as formatting). Could you use a picture link instead?

 

[vijaySharma]

srinidhi,


As Luke said it correctly you cannot do this using a UDF...


However this can be done using Procedures


Look at the file: https://docs.google.com/open?id=0BxRkrdCm95qbVzhqZUE0WFAwMVU


Let us know if this is what you were after...


For illustration I have only applied the background color of the Source cell to the destination cell... the code can be updated to include all the properties of the source cell to be applied on the destination cell.


HTH

~VijaySharma

 

[srinidhi]

Thanks Vijay,


This is what I was looking for.

 

[srinidhi]

Hi you can access the file from the below mentioned link, The data tab has the source data & it will change every week, I want the results as well as the formatting in the result tab, based on 2 conditions

1) Names in cell c1,d1,e1

2)based on coloum b

It will good, if the formula to get the data is imbibed in the macro itself.


https://docs.google.com/spreadsheet/ccc?key=0ArMlbNwyiUNHdDlsLXY0VlEwQWVfZVBGNE9ZSlk3dEE

 

[srinidhi]

Can any one, pls help me on this issue....

 

[srinidhi]

Hi, Can someone pls guide me on this issue.