format indexed cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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.
 
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

(e-mail address removed)
www.nickhodge.co.uk
 
Back
Top