I am trying to create an appointment book for four staff members to use
across a network. When an appointment is made, I would like the cell
containing the name of the client to be shaded (as well as the cell to the
immediate right of it) while all free appointment times remain white. I dont
know how to use istext and conditional formatting together when I am
conceivable affecting 365 days with 6 available times per day. Any ideas?