keep the formatting of the cell found using Hlookup

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

Guest

I have a data table set up that has wingdings2 as the format (to show a box
with a check mark). Each check indicates that a certain activity associated
with the row in the table is in play(a service will be performed). If a
service will not be performed than a box without a check mark in wingdings is
in the table. When I do a Hlookup to bring each element to a summary report
the lookup function returns the value which then must be reformatted. How do
I make sure the Hlookup function brings accross not only the value but the
format as well??
 
The problem is the cells in the table have two formats, one wingdings and one
wingdings2. So though the Wingdings will come out with the correct format,
the winddings2 does not. I was looking for a way to insert a formating
instruction within the Hlookup that would transfer with the data. Thank you
for the repsonse.
 
Denny,

You would need to put another row of formatting instructions into your
table, and use another HLOOKUP formula to return those instructions. Then
you could use the worksheet's calculate event to apply the correct
formatting to the cell with the first HLOOKUP formula.

Are you comfortable using macros?

HTH,
Bernie
MS Excel MVP
 
The problem is the cells in the table have two formats, one wingdings
and one wingdings2. So though the Wingdings will come out with the
correct format, the winddings2 does not. ...
Click to expand...

Maybe conditional formatting meets your need:
Format >> Conditional formatting
 
Back
Top