editing condtional formating rules to change IF "xxx" apears

**peppa** · 07-22-2011, 04:46 AM

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.

Please see attached.

**TMS** · 07-22-2011, 04:56 AM

Maybe:

=AND(AND(Y$4>=$Q8,Y$4<=$R8),AND($E8<>"",$E8<>"jabb"))

Regards

**peppa** · 07-22-2011, 05:11 AM

TMShucks;2567826]Maybe:

=AND(AND(Y$4>=$Q8,Y$4<=$R8),AND($E8<>"",$E8<>"jabb"))

Hallo, Thank you for your reply.

it does clear the cells but all of them, i just want it to clear the cells above the "jabb" cells in calander.

**TMS** · 07-22-2011, 05:22 AM

Please clarify which of the conditions you are trying to amend.

Regards

**peppa** · 07-22-2011, 05:34 AM

=AND(AND(Y$4>=$Q8,Y$4<=$R8),$D8<>"")
Want the dates in dark blue, to clear "only the dates of jabb" when "jabb" light blue in calander appears...

When i inserted the formula as per first responce it clears the whole section and not just the jabb dates on dark blue row.