Forum Discussion

KegelsPeter's avatar
KegelsPeter
Copper Contributor
Nov 09, 2019

Conditional formatting different cells

Hi all, I hope you can help me out here. As you can see in the picture the color of cel A15 till C22 needs to be blue if B20 = 3-Afgehaald. The color needs to be green if B20 = 2-Bevestigd, Gray wi...
Conditional Formatting
MohamedGadAllah's avatar
MohamedGadAllah
Copper Contributor
Nov 10, 2019

KegelsPeter 

If I got you correctly, do you need to create blocks for other days and then apply conditional format for these created blocks?

I am glad to help if you provide more information.

  • KegelsPeter's avatar
    KegelsPeter
    Copper Contributor
    Nov 12, 2019

    Hi MohamedGadAllah,

    It is difficult to explain. But the system is working as needed. The only problem is to copy the conditional formatting from one block to another.
    The refecence cell will alwasy be the one from the original and not from the new block.
    If i copy the conditional formatting from b15:c22 with the reference cell b10 to b25:c32 then the reference cell will still be b10.
    The reason is the format: =$B$10="4-Teruggebracht" .... then color.
    If i dot it like this: =$B10="4-Teruggebracht" .... then it is coloring just 1 cell and not the whole block.

    So i need a VBA code to make it working. If i need to do the conditional formatting for every block = 2x365 blocks.... That can not be the idea.

Resources