worksheet functions >> Changing Cell Color
maybe there is a conditional format set
try
Format > Conditional Format > Delete > Condition1 > Condition2 > Condition 3
> I am shading a cell but is it does not display the new color
worksheet functions >> Changing Cell Color
You highlight the cell you want to change, right click and go down to Format
Cells, click on patterns and choose your color. Is that not working for you?
> I am shading a cell but is it does not display the new color