Cell format and lookups

  • Thread starter Thread starter donh
  • Start date Start date
D

donh

Hi Group,

I have a time sheet which logs skills of those on duty. Cell
formatting is applied to the duty skill manager to easily distinguish
him on the time sheet.

I have created reference tables with links to these sheets and then
use lookups linked to a scroll bar to create a static master table so
managers are able to view skills available spanning the whole year.

The problem is that the formatting I use to show the duty manager is
of course not carried over to the master table. Is it possible to
read the original cell formatting and apply it to the master table
created by the lookups.

I have looked through help and found the cell function but it doesn't
seem fit my needs.


Any help as always appreciated.


PS I know I could achieve this by creating a modified cell value to
denote duty skill and have conditional formatting react to that but
there would be too many knock changes to make if I went that route.



Regards

DonH
 
Formulas return values--they don't retrieve the formatting.

Any chance you can use another field(s) in the original data and retrieve that,
too. Then (depending on how many options you're using and the version of excel
you're using), you may be able to use Format|Conditional formatting to change
the colors.
 
Formulas return values--they don't retrieve the formatting.

Any chance you can use another field(s) in the original data and retrieve that,
too. Then (depending on how many options you're using and the version of excel
you're using), you may be able to use Format|Conditional formatting to change
the colors.












--

Dave Peterson- Hide quoted text -

- Show quoted text -
Click to expand...

Dave,

I was hoping VBA could help by checking cells attributes and magic me
up a solution. looks like I'll have to update formulas. Thanks for
your help.

Regards

DonH
 
Can you do copy|Paste in code?

Depending on how things change, you may be able to tie into a worksheet event
(either _change or _calculate).
 
Back
Top