color filling

bic75

New Member
Joined
Nov 17, 2005
Messages
3
All of a sudden, I can't seem to apply color to any cell, it simply stays blank/white, yet when I look at the cell format, the color I chose is specified. :confused:
Does anyone know how to correct this?
Tks!
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Oorang

Well-known Member
Joined
Mar 4, 2005
Messages
2,071
Someone has probably applied a conditional format to the workbook. Try going to format, conditional formatting, delete, and then check all three boxes, click ok, click ok again. If the problem still persists, please advise if it is across all workbooks or just this one.
 

bic75

New Member
Joined
Nov 17, 2005
Messages
3
there's no conditionnal formatting and the problem is still there, on any workook. any other suggestions? thks.
 

bic75

New Member
Joined
Nov 17, 2005
Messages
3

ADVERTISEMENT

YES!!!! :biggrin:
Thanks ever so much! I'd read about this "high contrast" option, but I coudn't find it anywhere in the "appearance" settings, where I would have expected it to be. Anyway, problem solved. I'll now be able to sleep. Merci beaucoup!
 

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
Funny thing is that I knew I'd seen this problem before, but I had thought the cause was setting the Print in Black & White option in PageSetup Dlg box. When I tested that theory and it didn't pan out, I did a search here and found that thread. So I learned something too.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,381
Messages
5,571,804
Members
412,420
Latest member
Quintankerus
Top