Mar 17 2022 12:41 PM - last edited on Mar 17 2022 12:46 PM by Eric Starker
Mar 17 2022 12:41 PM - last edited on Mar 17 2022 12:46 PM by Eric Starker
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 fill colors. I don't have a lot of experience w this software. Can someone help me figure this out?
Mar 17 2022 12:45 PM
@casimir90 Hello! You originally posted this in the Tech Community Ideas space, which is meant for ideas for the Microsoft Tech Community website, not for questions about products and services such as Excel. I've moved your question into the Excel discussion space - please post Excel questions there in the future.
Mar 18 2022 02:33 AM
Solution@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.
Mar 18 2022 02:33 AM
Solution@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.