help with conditional formatting.

[matelot2]

<!--[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>

 

[matelot2]

Thanks for the offer Marcilio.
I tried to move just that section to a new worksheet to send it as you asked.
I then tried to go through it and confirm the problems had moved.
I started to alter some of the boxes and discovered that some of them were different, i.e. some were numbers, some were general and some were text, when I altered them all the general the boxes seemed to work.
I am still going through checking but I will put it on the site you suggested just for info when I can.
I think I have the problem in hand and will alter this thread to solved if I do.
In the mean time I would like to thank you all for your interest and offers to help. It is appreciated.

 

[matelot2]

Here is the link as promised.

https://www.sendspace.com/file/2xnbq1

It seems to work fine now. I will keep playing with it and see if it needs to be formatted as number/general for instance.
Thanks for the help.

 

[matelot2]

sendspace is a bit odd?
I managed to upload the file and then download it by clicking on the link in the last thread even though it kept saying I need to log on and send credit card details, which it promised me would not be used, why does it need them then? no chance.
Maybe I found a loophole or they let you up and down load files but hide the fact in all the adverts?
strange.

 

[matelot2]

I thought I had seen a box to mark this as solved? I can't find it now?