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!
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
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.
 
Upvote 0
there's no conditionnal formatting and the problem is still there, on any workook. any other suggestions? thks.
 
Upvote 0
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!
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,211,983
Messages
6,105,215
Members
447,956
Latest member
haluxuxjr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top