| 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? |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
Thanks Morrigan
I couldnt make that work. I've not used conditional formatting before which is why I'm a bit vague about all this. I need the cell containing the name of the person who has booked an appointment to become grey to help identify the other free appointment times and your suggestion left the cell grey until I clicked away from it. Any other ideas? Thanks for your time! "Morrigan" wrote: 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 |
|
#4
|
|||
|
|||
|
What this formula does is whenever A1 is not empty, it will be shaded. Let's say you input John Smith into cell A1, then A1 should turn grey. Once you delete the name, A1 should be white again. Is that how you want it? Heather at WEO Wrote: Thanks Morrigan I couldnt make that work. I've not used conditional formatting before which is why I'm a bit vague about all this. I need the cell containing the name of the person who has booked an appointment to become grey to help identify the other free appointment times and your suggestion left the cell grey until I clicked away from it. Any other ideas? Thanks for your time! "Morrigan" wrote: 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 -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=390717 |
|
#5
|
|||
|
|||
|
OK, got that working, thanks Morrigan! Now, any idea how to copy that
conditional format to innumerable cells? I take it I cant do the same but format the cells' alignment (ie, merge them)? "Morrigan" wrote: What this formula does is whenever A1 is not empty, it will be shaded. Let's say you input John Smith into cell A1, then A1 should turn grey. Once you delete the name, A1 should be white again. Is that how you want it? Heather at WEO Wrote: Thanks Morrigan I couldnt make that work. I've not used conditional formatting before which is why I'm a bit vague about all this. I need the cell containing the name of the person who has booked an appointment to become grey to help identify the other free appointment times and your suggestion left the cell grey until I clicked away from it. Any other ideas? Thanks for your time! "Morrigan" wrote: 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 -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=390717 |
| Reply |
| 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 | |||
Linear Mode
