How To Effortlessly Undo Conditional Formatting In Your Spreadsheets
To remove conditional formatting, select the cells containing the formatting, click the ‘Clear Format’ button on the Home tab, and choose ‘Clear Rules from Selected Cells.’ This action removes the formatting rules while retaining any other formatting attributes. Alternative methods include using the Format Painter to remove formatting or manually deleting the conditional formatting attributes….