Forum Discussion
pmayes
Mar 07, 2026Copper Contributor
remove background shading
Is there a way in Excel where columns are shaded a color, but when I put an S or P in a cell that it removes that background color in that cell and the cell to the right, example B9 is shaded blue an...
NikolinoDE
Mar 10, 2026Platinum Contributor
Please do not post the same message twice, as this will not lead to a faster response and will take up more time and resources.
=OR($B9="S",$B9="P")
same formula and same Post...change background color