Forum Discussion
Solved
Cut and paste (rows) and then change fill color of rows
I am having an issue w/ Excel. I have a table I inherited when I joined this company. I am trying to cut and paste (rows) and then change fill colors of rows. The table does not allow me to change fi...
casimir90 I suspect that the colors are set by conditional formatting (CF). On the Home ribbon, look for this icon.
Select the cells you want to change, click the CF icon and "Clear rules from selected cells".
Now, all conditional colors will be gone and you are probably left with the colors that you tried to add to the cells before.
casimir90 I suspect that the colors are set by conditional formatting (CF). On the Home ribbon, look for this icon.
Select the cells you want to change, click the CF icon and "Clear rules from selected cells".
Now, all conditional colors will be gone and you are probably left with the colors that you tried to add to the cells before.
Thanks