background color based on other cell background color.

  • Now the cells on the calendar are colored by a contidional formating.
    But what i whant is the the user can change the backcolor by changing the Color in r4

    the for the saterday and Sunday
    i now that i can change the collor for both on bye the

    [SIZE=13px]contidional formating
    in don't want that the user must change the contidional formating he must oly change the color of R4 R6

    And the same for the cells of the black rectangle. =R11
    so not with copy past of R11 only by changing the color there[/SIZE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!