Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #109380

Re: Colormarking of fields based on colors in another sheet (difficult !!)

Show all headers | View raw

i Johan,

if you could upload the file on (cjoint.com, or other ) course without
confidentielles' data,  it would help us to help you!

isabelle

Le 2016-10-04 à 12:01, jmslab@xs4all.nl a écrit :
> Hello, big challange to make ! (for me). Perhaps somebody can help me out.
>
>
> In Sheet1 I have 66 Columns and appr 60 records. Column A = TextCode1 (like
> 3A, 3B, etc..), Column B = TextCode2 (like A, B, etc..), Column C till BN is
> heading nr.1 till 64. In the records of Column C till BN are specific records
> only 'green' colored (filled color). There is no data/value registered in it.
> Only the color.
>
> In Sheet2 I have the same columns but now started from Column K. (TextCode1
> in Column K, TextCode2 in Column L and the headings nr.1 till 64 in the
> Columns M till BX). In sheet 2 are in the datafields of column M till BX
> values registered.
>
> I like to have a module which;
>
> Loop in Sheet2 from record 2 till last. Based on TextCode1+TextCode2, Lookup
> in Sheet1 to the identical TextCode1+TextCode2 and then copy the colorformat
> from that row (from C till BN) from sheet 1 to this record in sheet2 in the
> columns M till BX of the specific record of the loop. Based on the identical
> code, you will get then the same colored records.
>
> Finally; A module thats overlooks all records in Sheet2. If the colored
> record is 'green' but there's no value registered, then color the field
> 'orange'. If there's is a value registered in a field that isn't 'green' then
> color the record 'red'.
>
> So,......  if there's a better creator then me :) So please. Thanks !!
>
> regards, Johan.

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Colormarking of fields based on colors in another sheet (difficult !!) jmslab@xs4all.nl - 2016-10-04 09:01 -0700
  Re: Colormarking of fields based on colors in another sheet (difficult !!) isabelle <i@v.invalid> - 2016-10-07 21:11 -0400
    Re: Colormarking of fields based on colors in another sheet (difficult !!) jmslab@xs4all.nl - 2016-10-08 09:51 -0700
      Re: Colormarking of fields based on colors in another sheet (difficult !!) isabelle <i@v.invalid> - 2016-10-08 21:56 -0400
        Re: Colormarking of fields based on colors in another sheet (difficult !!) jmslab@xs4all.nl - 2016-10-08 22:51 -0700
          Re: Colormarking of fields based on colors in another sheet (difficult !!) isabelle <i@v.invalid> - 2016-10-09 23:23 -0400
            Re: Colormarking of fields based on colors in another sheet (difficult !!) isabelle <i@v.invalid> - 2016-10-10 03:57 -0400
              Re: Colormarking of fields based on colors in another sheet (difficult !!) isabelle <i@v.invalid> - 2016-10-10 04:24 -0400
                Re: Colormarking of fields based on colors in another sheet (difficult !!) jmslab@xs4all.nl - 2016-10-10 04:20 -0700
                Re: Colormarking of fields based on colors in another sheet (difficult !!) isabelle <i@v.invalid> - 2016-10-13 22:37 -0400
                Re: Colormarking of fields based on colors in another sheet (difficult !!) jmslab@xs4all.nl - 2016-10-13 20:40 -0700
                Re: Colormarking of fields based on colors in another sheet (difficult !!) isabelle <i@v.invalid> - 2016-10-14 09:01 -0400
  Re: Colormarking of fields based on colors in another sheet (difficult !!) xethubao 123 <xethubao 123@gmail.com> - 2016-10-10 02:38 +0100

csiph-web