Fill color after conditional formating

[salim9696]

Hi, i did conditional formatting everything is good is working, but i after conditional formatting i couldn't change cells color manually it seems these is hiding under conditional formatting color. Can u help me pls fix this. I also wana have opportunity to fill cells color manually and i wana to see it also. In the screenshot u can see left part where i have conditional formating and cells in this part is not showing colors but in the right part we see colors. I wana also see colors in the left part after conditional formating.

 

[GWteB]

after conditional formatting i couldn't change cells color manually it seems these is hiding under conditional formatting color.

That's the whole point of CF. If (one of) the conditon(s) is met the according format is applied. If none of the conditions are met, the initial format is displayed.

 

[salim9696]

That's the whole point of CF. If (one of) the conditon(s) is met the according format is applied. If none of the conditions are met, the initial format is displayed.

So it means i will not able to change manualy collor of the cells ?

 

[GWteB]

It is still possible to change the initial color manually, but this change will only become visible if none of the CF conditions are met.

 

[salim9696]

It is still possible to change the initial color manually, but this change will only become visible if none of the CF conditions are met.

okey, thanks buddy. I just fix this I made loop in the vba. Thanks anyway

 

[GWteB]

Glad it's sorted and thanks for the feedback