| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to alter cell format if cell contains text
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format cell from data input to output form | Excel Worksheet Functions | |||
| 16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
| How do I format a cell with numbers, text and hyphens | Excel Discussion (Misc queries) | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Threaded Mode
