colours missing in conditional formatting.

  • Thread starter Toobi-Won Kenobi
  • Start date
T

Toobi-Won Kenobi

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
 
G

Gord Dibben

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
 
D

David Biddulph

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?
 
T

Toobi-Won Kenobi

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
 
T

Toobi-Won Kenobi

Hello Gord,

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

Many thanks for the link

TWK
 
Top