colours missing in conditional formatting.
 

Can anyone give some pointers as to why a spreadsheet containing conditional
formatting displays as expected on my PC, yet when opened by a colleague
(several miles away) the cells are not filled with the expected colour,
though the values and CF is unchanged. Both PCs ar using Excel 2003.
Regards
TWK

colours missing in conditional formatting.
 

Does any other background color show up or just the CF'd cells?

Perhaps this may shed some light if all color is not showing.

http://support.microsoft.com/default.aspx?kbid=833258

The fill color, the fill pattern, or the line color of a WordArt or
AutoShape object in an Office document does not change

As directed, change the colleague's High Contrast setting in Windows OS


Gord Dibben MS Excel MVP


On Wed, 2 May 2007 22:31:59 +0100, "Toobi-Won Kenobi" <Toobi-won
wrote:

Can anyone give some pointers as to why a spreadsheet containing conditional
formatting displays as expected on my PC, yet when opened by a colleague
(several miles away) the cells are not filled with the expected colour,
though the values and CF is unchanged. Both PCs ar using Excel 2003.
Regards
TWK

colours missing in conditional formatting.
 

You may need to give us a clue by telling us what CF conditions you
specified, and what the contents of the cells in question are?

Are you using dates, and are the Windows regional settings different between
the two machines?
--
David Biddulph

"Toobi-Won Kenobi" <Toobi-won wrote in message
...
Can anyone give some pointers as to why a spreadsheet containing
conditional formatting displays as expected on my PC, yet when opened by a
colleague (several miles away) the cells are not filled with the expected
colour, though the values and CF is unchanged. Both PCs ar using Excel
2003.
Regards
TWK

colours missing in conditional formatting.
 

Hello David,

The condition is "Formula is
=AND((122*LEFT(G10,1)-CODE(RIGHT(G10,1)))=23,(122*LEFT(G10,1)-CODE(RIGHT(G10,1)))<=267)
It takes the values of the cell, which could be 1a up to 5c ( I know they
look like cell addresses but that is what they wanted) in their case 1c is
greater than 1a and so on. (23 and 267 change so as to reflect a higher
condition band) eg 268 - 389 and 390-513
This has worked perfectly well for the past three years.
Regards

TWK


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
You may need to give us a clue by telling us what CF conditions you
specified, and what the contents of the cells in question are?

Are you using dates, and are the Windows regional settings different
between the two machines?
--
David Biddulph

"Toobi-Won Kenobi" <Toobi-won wrote in message
...
Can anyone give some pointers as to why a spreadsheet containing
conditional formatting displays as expected on my PC, yet when opened by
a colleague (several miles away) the cells are not filled with the
expected colour, though the values and CF is unchanged. Both PCs ar using
Excel 2003.
Regards
TWK

colours missing in conditional formatting.
 

Hello Gord,

I don't know about, she didn't say, I will check.

Many thanks for the link

TWK


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Does any other background color show up or just the CF'd cells?

Perhaps this may shed some light if all color is not showing.

http://support.microsoft.com/default.aspx?kbid=833258

The fill color, the fill pattern, or the line color of a WordArt or
AutoShape object in an Office document does not change

As directed, change the colleague's High Contrast setting in Windows OS


Gord Dibben MS Excel MVP


On Wed, 2 May 2007 22:31:59 +0100, "Toobi-Won Kenobi" <Toobi-won
wrote:

Can anyone give some pointers as to why a spreadsheet containing
conditional
formatting displays as expected on my PC, yet when opened by a colleague
(several miles away) the cells are not filled with the expected colour,
though the values and CF is unchanged. Both PCs ar using Excel 2003.
Regards
TWK