Conditional Formatting on a Linked Cell

[clb]

When I apply conditonal formatting to a linked cell in my spreadsheet it does
not work. Is there someway to get this to work? I am trying ot get eh vale
to be bold if it is geater than a fixed value.

The cell link is =UPLOAD!J107 that I am trying to format conditionally.

Thanks

 

[T. Valko]

Works OK for me.

What cell do want to conditionaly format and how did you try to apply it?

 

[Shane Devenshire]

Hi,

Works fine for me.

1. what version of Excel are you using
2. is J107 a number?
3. try applying a pattern and see if that works

 

[clb]

I am using Excel 2003, J107 is a number from another spreadsheet that is
updated and the link is used to update my master spreadsheet. I tried the
pattern and it did not work with the greater sign but did with a less than
(opposite of the logical test). The formatting did not change when I put in a
value that should have made the pattern go away when the link updated the
master sheet.