Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting I can't seem to figure out......
This is easy and I know I am overlooking something, but I was hoping one of you could help. If B14 equals N123AB then shade Cell I14 black. I tried this formula in the conditional formatting box: =if(B14="N123AB",) and it accepts the formula, but it wont do any shading. There is already a formula in I14. Does that matter or can I have a formula in the formula box and then another conditional formula in the condiditonal formatting box???? If it does matter,, the formula that is already in I14 is: =IF(OR(F6="N123AB",F6="N4AP",F6="N213AC",F6="N742X "),H14,"") So essentially, if F6= N123AB (or 1 of the other stated values) then I want I14 to be shaded while retaining the formula already in I14. Does any of this make sense? Thanks in advance. Mcr1 -- mcr1 ------------------------------------------------------------------------ mcr1's Profile: http://www.excelforum.com/member.php...o&userid=15496 View this thread: http://www.excelforum.com/showthread...hreadid=499473 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting I can't seem to figure out......
Select I14
FormatConditional Formatting Change Condition 1 to Formula Is Add a formula of $B$14="N123AB" Format and exit -- HTH Bob Phillips (remove nothere from email address if mailing direct) "mcr1" wrote in message ... This is easy and I know I am overlooking something, but I was hoping one of you could help. If B14 equals N123AB then shade Cell I14 black. I tried this formula in the conditional formatting box: =if(B14="N123AB",) and it accepts the formula, but it wont do any shading. There is already a formula in I14. Does that matter or can I have a formula in the formula box and then another conditional formula in the condiditonal formatting box???? If it does matter,, the formula that is already in I14 is: =IF(OR(F6="N123AB",F6="N4AP",F6="N213AC",F6="N742X "),H14,"") So essentially, if F6= N123AB (or 1 of the other stated values) then I want I14 to be shaded while retaining the formula already in I14. Does any of this make sense? Thanks in advance. Mcr1 -- mcr1 ------------------------------------------------------------------------ mcr1's Profile: http://www.excelforum.com/member.php...o&userid=15496 View this thread: http://www.excelforum.com/showthread...hreadid=499473 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting I can't seem to figure out......
Hmmm. Still didn't work. Thanks for your help. O'll keep playing with it. -- mcr1 ------------------------------------------------------------------------ mcr1's Profile: http://www.excelforum.com/member.php...o&userid=15496 View this thread: http://www.excelforum.com/showthread...hreadid=499473 |
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) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |