Hallo all... pls assist
Have set up an roaming calander that is conditional formatted to colour the dates between the start and end date in "blue" from data sheet. If "jabb" appears in the next row i want the rule of the colum above "jabb row" to change to clear "no fill" as if a space was made for the jabb.
Maybe something like this # with some help
=AND(AND(Y$4>=$Q8,Y$4<=$R8),AND($E8<>"",$E8<>"jabb"))
but clears the whole row, and not just the "jabb" from the next line dates.
<!-- / message --><!-- attachments -->
Have set up an roaming calander that is conditional formatted to colour the dates between the start and end date in "blue" from data sheet. If "jabb" appears in the next row i want the rule of the colum above "jabb row" to change to clear "no fill" as if a space was made for the jabb.
Maybe something like this # with some help
=AND(AND(Y$4>=$Q8,Y$4<=$R8),AND($E8<>"",$E8<>"jabb"))
but clears the whole row, and not just the "jabb" from the next line dates.
