I dont know if its suitable in this sub-forum, but i think this problem didn't suitable with excel function ( Correct me if i wrong )
In my case, i want to copy the colored cell, from this table (1) :
2.JPG
to this table (2) :
1.JPG
So if table (1) cell colored yellow, table (2) is colored yellow too in same place too Automatically
we can see cell M59 ( table 1 ) colored yellow and i want cell M13 ( table 2 ) is colored yellow too
Note :
i put conditional formatting in table (1) if numbered in range 0 until 0.6 colored by yellow
Thanks
Bookmarks