ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   back ground color doesn't work in cell. (https://www.excelbanter.com/excel-worksheet-functions/49123-back-ground-color-doesnt-work-cell.html)

Soother

back ground color doesn't work in cell.
 
In excel....
When I try to use the "spilled paint bucket" icon
to color the cell backgroud nothing happens. It stays white.


Max

One guess is the cell could have underlying conditional formatting CF) set
to say, fill-color white if the cell contains nothing ("").

You could check / delete the CF by selecting the cell
and clicking Format Conditional Formatting
Click Delete, select as appropriate OK out

To quickly select all cells on the sheet with CF
with any cell selected on the sheet,
just press F5 Special Conditional formats OK

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Soother" wrote in message
...
In excel....
When I try to use the "spilled paint bucket" icon
to color the cell backgroud nothing happens. It stays white.





All times are GMT +1. The time now is 02:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com