Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting help.
Im creating a planner for my local GP which, ive got a small problem with. Basically on it its got, the ammount of appointments each Gp has, and above it has whether they are "in" on that day or "off". But the Problem is that when someone is on holiday, a "h" goes into the box, i want this then to turn the box with the ammount of appointments in to "0". I've tried using the basic "IF" fuction: =IF(A1="H",0), which makes the box go to 0 when there is a h but i cant type any other number into that cell because it will over ride the forumlae in the cell. I then tried to type the same forumlea into the conditional formatting section but that just does nothing. If you have any way of solving this problem please help me. Thanks -- mikel301292 ------------------------------------------------------------------------ mikel301292's Profile: http://www.excelforum.com/member.php...o&userid=35004 View this thread: http://www.excelforum.com/showthread...hreadid=547423 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting help.
Mike, One way to do this is through Data validation (DATA Validation) In the cell where you want the numbers or 0 to be go to data validation Select list then in the box put =IF(Cell_that_has_H="h",0,1,2,3,4,etc) This will only allow 0 to be entered into the cell when H is selected, make the list of numbers as long as you like/need or you could use a named range. Not all that pretty but it works. Ed -- EdMac ------------------------------------------------------------------------ EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736 View this thread: http://www.excelforum.com/showthread...hreadid=547423 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting help.
Thanks for your help Ed, but The problem isnt with the manual entering of the number, i need it to automatically change when "h" is entered into the cell. -- mikel301292 ------------------------------------------------------------------------ mikel301292's Profile: http://www.excelforum.com/member.php...o&userid=35004 View this thread: http://www.excelforum.com/showthread...hreadid=547423 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting help.
Mike, In that case, I think the only solution would be using a macro - not my strong point I'm afraid but I'm sure there are others on the site who may be able to help you. Ed -- EdMac ------------------------------------------------------------------------ EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736 View this thread: http://www.excelforum.com/showthread...hreadid=547423 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |