Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format indexed cell
A function can only return a value. It is not able to change properties or
attributes. You could consider 'what makes the referenced cell bold', e.g positive, greater than budget, highest value, etc and apply conditional formatting to the result cell -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "lh" wrote in message ... =INDEX($C$1:$BA$66,MATCH($C117,$C$1:$C$66,0),22) Can someone assist with how to have the indexed cell have the same formatting as the original cell. For example, the original cell is bold, but the cell that is indexing does not reference bold, simply the value. Essentially I have a look-up table with values. The lookup table cell is bold, but the cell that references the look-up is plain text and not bold. Using the paint function would be quite time consuming and reduces the value of using a look-up table. Thank you for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Cell data format | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) |