<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--> I am using excel 2003. Part of office professional 2003.
I am trying to get a number in box H43 to go to red if the contents of box E23 is higher and go to green if box 23 is lower or same.
I highlight box H43
In conditional formatting
<format conditional="" formatting=""> Format/conditional formatting
I put
Condition 1
Cell value is less than or equal to E23
AaBbCcYyZz
Condition 2
Cell value is greater than E23
AaBbCcYyZz
The conditional box always changes to ="E23" but I suppose this is the correct format for the condition?
If I try to change it, it just adds extra “” around it.
I have checked that both cells have
<format cells="" number=""> Format/cells/number
set to number with ‘0’ decimal places.
Cell H43 stays green no matter what else I do, even if I manually change the contents of box E23 to a number lower or higher than the contents of box H43, the contents are just a number I have entered and not a formula from somewhere else.
Can anyone see what I am doing wrong?
<!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if !mso]>******** classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui></object> <style> st1\:*{behavior:url(#ieooui) } </style> <![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--></format></format>
I am trying to get a number in box H43 to go to red if the contents of box E23 is higher and go to green if box 23 is lower or same.
I highlight box H43
In conditional formatting
<format conditional="" formatting=""> Format/conditional formatting
I put
Condition 1
Cell value is less than or equal to E23
AaBbCcYyZz
Condition 2
Cell value is greater than E23
AaBbCcYyZz
The conditional box always changes to ="E23" but I suppose this is the correct format for the condition?
If I try to change it, it just adds extra “” around it.
I have checked that both cells have
<format cells="" number=""> Format/cells/number
set to number with ‘0’ decimal places.
Cell H43 stays green no matter what else I do, even if I manually change the contents of box E23 to a number lower or higher than the contents of box H43, the contents are just a number I have entered and not a formula from somewhere else.
Can anyone see what I am doing wrong?
<!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if !mso]>******** classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui></object> <style> st1\:*{behavior:url(#ieooui) } </style> <![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--></format></format>
Last edited: