Select the two cells you want to be shaded - Conditional Formatting

Formula is =COUNTA($A1)


Hope this helps.



Heather at WEO Wrote:
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?


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=390717