the cells have a number associated with it which looks something like this ,column A & B will never have any color the columns and rows are dynamic
![Image Image](/board/proxy.php?image=https%3A%2F%2Ffilestore.community.support.microsoft.com%2Fapi%2Fimages%2F351d7013-136d-43b9-9e20-b1b2c0802fc6%3Fupload%3Dtrue%26fud_access%3DwJJIheezUklbAN2ppeDns8cDNpYs3nCYjgitr%252BfFBh2dqlqMuW7np3F6Utp%252FKMltnRRYFtVjOMO5tpbpW9UyRAwvLeec5emAPixgq9ta07Dgnp2aq5eJbnfd%252FU3qhn54B0H%252F4la0KPpb26hO0pdIs7YNPkFNxinoGeAOEfFS22J6k7OqZDzIxHB2IOMWp3FKzeJ%252F5qya7ZuiRsMToFuKp5Bi%252B8t4Iaw3ZGW7mtZReAZwGuDviOieumcDmWyTEI%252FfmHnhDnhubu7IPxrs4DkEPwZUqX35jOopiBRUPEMm2VA6EhT9DqDYVGao0ETx%252FWZk22%252BL14Y%252F4awjLmytzj%252FS%252F9dBShwEPHHxKOJpLDrPat0A0jts2etJ2Nru8%252ByGdEMN6S7rXWqrT540F6K3XgvVF5jvY0kWAtZh6k0ier1IlbQ%253D&hash=00c723d750f572c5fef1121541074689)
the Output is expected something like the below. the green columns B-C should only be populated when the whole line is green
and only first red cell and its value should be populated in the red column D-F
![Image Image](/board/proxy.php?image=https%3A%2F%2Ffilestore.community.support.microsoft.com%2Fapi%2Fimages%2Fe1dd1899-8e36-4e30-bb3b-37191e4bd09e%3Fupload%3Dtrue%26fud_access%3DwJJIheezUklbAN2ppeDns8cDNpYs3nCYjgitr%252BfFBh2dqlqMuW7np3F6Utp%252FKMltnRRYFtVjOMO5tpbpW9UyRAwvLeec5emAPixgq9ta07Dgnp2aq5eJbnfd%252FU3qhn54B0H%252F4la0KPpb26hO0pdIs7YNPkFNxinoGeAOEfFS22J6k7OqZDzIxHB2IOMWp3FKzeJ%252F5qya7ZuiRsMToFuKp5Bi%252B8t4Iaw3ZGW7mtZReAZfQBBlqR72xDEUjKzctkWvUytGEgT27IyP%252BU5TU8kkLw%252ByUidRWGwu3tenv7boPM%252BrTA9BIYGrg1oHknf%252F1xe7qrrnMAed2fUIV6PmyYfaXd7Rj9KEcsjnaHqVCifSrRUi1zuXM%252BBcfHi0Vbm%252BIZ28sd6xB3jrQkJ2I1IM42uLOLBrQ%252Fg4LRxG8BjZRFJ6TsU%253D&hash=675460e8ea29e63d6a2007e1fbf90322)
can you please help with the code modifications required above link.
Redirecting
the Output is expected something like the below. the green columns B-C should only be populated when the whole line is green
and only first red cell and its value should be populated in the red column D-F
can you please help with the code modifications required above link.
Redirecting