To copy the contents and the formatting, choose All merging conditional formats. To combine your copied formats with existing conditional formats in the paste area, click the Merge Conditional ...

Whether you're comparing a single list or several, Excel's conditional formatting can get the job done.

Thanks to the linked cell property in Microsoft Excel, it's super easy to use the selected value as a condition in a macro or conditional formatting rule.

We've covered a lot about using custom formulas for conditional formatting in Google Sheets, especially color-coding cells based on the date. Now let's look at how to color-code cells based on whether ...